cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
werdinka Frequent Visitor
Frequent Visitor

DAX forecast measure - handling blanks in forecast

Hi Guys, I am trying to calculate strange "forecast" for client which should show sum of values for current month till the end of the year - I've built this function and it works okey for non blank values. It seems that if there is no real data for example March in forecast value from February is shown instead of blank(for example if service was not provided this month) . Could you please advice how to handled blank values in forecast? 

 Capture.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: DAX forecast measure - handling blanks in forecast

Hi,

 

Here's the result i got.  You may download the Excel file from here.

 

Hope this helps.

 

Untitled.png

11 REPLIES 11
Community Support Team
Community Support Team

Re: DAX forecast measure - handling blanks in forecast

Hi @werdinka

Could you give an example of your dataset showing on this table(or matrix?) and show me how you calculate the measure"forecast"?

Which data is orginal data and which are from your measure?

 

Best Regards

Maggie

werdinka Frequent Visitor
Frequent Visitor

Re: DAX forecast measure - handling blanks in forecast

Hi, I hopev this helps:

 

Capture.PNGCapturde.PNG

Super User
Super User

Re: DAX forecast measure - handling blanks in forecast

Hi,

 

Share the link from where i can download your Excel file.

Highlighted
werdinka Frequent Visitor
Frequent Visitor

Re: DAX forecast measure - handling blanks in forecast

Hi, 

 

below there's a link. Thanks in advance!

 

https://uploadfiles.io/lnxpe

Super User
Super User

Re: DAX forecast measure - handling blanks in forecast

Hi,

 

Here's the result i got.  You may download the Excel file from here.

 

Hope this helps.

 

Untitled.png

werdinka Frequent Visitor
Frequent Visitor

Re: DAX forecast measure - handling blanks in forecast

Ashish!

 

Thank you so much - this is perfect!

Super User
Super User

Re: DAX forecast measure - handling blanks in forecast

You are welcome.

werdinka Frequent Visitor
Frequent Visitor

Re: DAX forecast measure - handling blanks in forecast

Ashish, one more thing. I would like grand total to show sum of my calculated field -( I am talking about the formula I wrote in file previously) -  Why they are so different ? (The last show result from sum formula) 

Capture.PNG

 

Super User
Super User

Re: DAX forecast measure - handling blanks in forecast

Hi,

 

Your question is not clear.  Do you want the Grand total appearing in column N of the image that i posted to be the summation of the numbers from column B:M?