handling blanks in forecast

Anything related to PowerPivot and DAX Formuale
Werdinka
Posts: 1
Joined: Wed Jun 27, 2018 11:07 pm

handling blanks in forecast

Postby Werdinka » Wed Jun 27, 2018 11:15 pm

Hi Guys,

I am trying to build formula to calculate forcast which should always show data from current month in next months.
There is a case that some products were not sold that month so pipvot table shows blank. I used below function and it works but if in current month there were no values for the product it show values from the first found month with values instead of blank.
Test2:=CALCULATE((CALCULATE([SumofAmount],filter(all('Calendar'),Calendar[Date]=MAX([Period])))),filter(all('Calendar'),Calendar[Date]<=MAX(Calendar[Date])))

Please help me how to solve it

andredl
Posts: 59
Joined: Wed Sep 23, 2015 9:56 pm

Re: handling blanks in forecast

Postby andredl » Sat Jun 30, 2018 7:51 pm

Have you tried this:
Qty sold previous month = CALCULATE([Qty sold],DATEADD('Calendar'[Date],-1,month))


Return to “PowerPivot/DAX”

Who is online

Users browsing this forum: No registered users and 7 guests