When I add a new measure (in to the value field) that provides the difference between actual and plan, I'm getting two additon al column
This is how i'm calculting variance
Variance = CALCULATE(sum(PB01[Sales]),PB01[Scenario]="Actual")- CALCULATE(sum(PB01[Sales]),PB01[Scenario]="Plan")
This is what i'm getting
Customer Actual variance Plan Variance
Abc Inc 7 3 10 3
The dataset has the following colums
Scenario : Actual, Plan
Solved! Go to Solution.
Yes. This is the setting for the matrix;
Row : Customers
I tried to add new calculated field ( variance) to the Value and got two additional columns
Cool, you have two values for each scenario, two scenarios * two values = four columns
Hi I have a similar problem
I am getting
Qtr1 | Qtr2
Product | total sales | variance | total sales | variance
Qtr1 | Qtr2 |
Product | total sales | total sales | variance
can you help ?
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.