cancel
Showing results for
Did you mean:
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?

1 ACCEPTED SOLUTION

Accepted Solutions
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.

11 REPLIES 11
Community Support Team

## Re: DAX forecast measure - handling blanks in forecast

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

Frequent Visitor

## Re: DAX forecast measure - handling blanks in forecast

Hi, I hopev this helps:

Super User

Hi,

Highlighted
Frequent Visitor

Hi,

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.

Frequent Visitor

## Re: DAX forecast measure - handling blanks in forecast

Ashish!

Thank you so much - this is perfect!

Super User

You are welcome.

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)

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?