Actuals where they exist else plan

[Anonymous]

Hi All, 

Is it possble to come up with a measure that gives me the actuals where they exist else budget. 

For e.g., If we have actuals until jan, then i would like to see the graph showing JAN ACTUALS and from FEB to DEC budget. 

Thanks!!

[amitchandak · Accepted solution]

Try like.

Actual = sum(table[Actual])

Budget= sum(Budget[Budget])

Over all = if(isbalnk([Actual] ),[Budget],[Actual])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin

[ImkeF · Accepted solution]

Yes, but for the (sub) totals to add up correctly, you have to iterate through your date-dimension and calculate the value on a row-by row-basis. Whether that's the month- or day (or other) level, depends on your business requirements, but the general setup would look like so:

SUMX( Calendar[Month], if ( isblank( [Actual] ); [Budget]; [Actual] ) )

[Actual] and [Budget] being measures here.

[v-xuding-msft]

Hi @Anonymous ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

I agree with Imke Feldmann. You could reference the simple sample that I have done before.

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ImkeF · Accepted solution]

Yes, but for the (sub) totals to add up correctly, you have to iterate through your date-dimension and calculate the value on a row-by row-basis. Whether that's the month- or day (or other) level, depends on your business requirements, but the general setup would look like so:

SUMX( Calendar[Month], if ( isblank( [Actual] ); [Budget]; [Actual] ) )

[Actual] and [Budget] being measures here.

[amitchandak · Accepted solution]

Try like.

Actual = sum(table[Actual])

Budget= sum(Budget[Budget])

Over all = if(isbalnk([Actual] ),[Budget],[Actual])

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution.
In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blogs -Decoding Direct Query - Time Intelligence, Winner Coloring on MAP, HR Analytics, Power BI Working with Non-Standard TimeAnd Comparing Data Across Date Ranges
Proud to be a Datanaut Connect on Linkedin