Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
i have the below data in excel
and then i have a powerbi table
i would like to have another column with the variance per month.
any idea?
thank you
Solved! Go to Solution.
Hello you probably want to make three measures (if you havent already made the first 2)
1. Actual=SUM(Table1[Actual])
2. Budget=SUM(Table1[Budget])
3. Variance=[Actual]-[Budget]
Drag them all into your table
Hello, you need to have the three measures i mentioned earlier, each dragged in. I think you have just a single measure there with the actual/budget as a column header.
Hello you probably want to make three measures (if you havent already made the first 2)
1. Actual=SUM(Table1[Actual])
2. Budget=SUM(Table1[Budget])
3. Variance=[Actual]-[Budget]
Drag them all into your table
thank you @samdthompson that worked great but ihave a follow up.
i have a matrix and if i add the measure "Variance" at that matrix it appears at both columns like below
how can i remove the column marked with blue?
thanks in advance
Hi,
These measures should work
Budget total = calculate(sum(Data[amount]),data[type]="budget")
Actual total = calculate(sum(Data[amount]),data[type]="actual")
Variance = [budget]-[actual]
To your Table, visual, drag Month and Year from the Calendar table and the 3 measures written above.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |