Forum Discussion
Find Average and find difference from month values
Hi Experts
See attached sample Date file https://www.dropbox.com/s/jzl1j68j43md8gd/Test_data.pbix?dl=0
See image
Based on image above and sample data file i want to work out the average for each month and subtract that value away from the total supply for that Provider
For Example EA Supplies 55,744.84 each month the Average is (55744.84+55498.92+55461.97)/3 then take this away from 55744.84 and just show the difference in above table.
Hi,
Remove the date hierarchy that you dragged to the row labels. Drag the Year and Month name columns from the Calendar Table. Sort the Month name column by the Month number column. Write these measures
Measure = AVERAGEX(ALL(global_oil_balances[Provider]),[Average Balance])Measure 2 = [Average Balance]-[Measure]hope this helps.
2 Replies
- lbendlin
Super User
You want to show how each of them performs compared to the average? As a percentage or as a delta value?
see attached
- Ashish_Mathur
Hi,
Remove the date hierarchy that you dragged to the row labels. Drag the Year and Month name columns from the Calendar Table. Sort the Month name column by the Month number column. Write these measures
Measure = AVERAGEX(ALL(global_oil_balances[Provider]),[Average Balance])Measure 2 = [Average Balance]-[Measure]hope this helps.
