cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
analyst31 Regular Visitor
Regular Visitor

Budget to Actual variance in a matrix

I have a financial report that i have created, it is almost complete and the last part is to add a budget to actual variance column in the matrix. I am trying to get it to the right of the "Totals Column". I tried creating a new measure, but it was breaking it up by months and summing the variance together, i tried to click on "dont summarize" option on the values drop down, but it was not there.

 

Here is what the reports looks like so far

 

2 REPLIES 2
Super User
Super User

Re: Budget to Actual variance in a matrix

In your measure, you should probably use HASONEVALUE on your Month and if so, return BLANK(), otherwise, do your calculation.


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!


Moderator v-yuezhe-msft
Moderator

Re: Budget to Actual variance in a matrix

@analyst31,

Please share sample data of your table and post expected result following the guide in https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490.

We will provide you appropriate DAX based on your sample data.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.