Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi
I am very new to Power BI and maybe I am having troubles understanding how it behaves.
I have below table were a have my monthYear and I have a summarized price. Then I have a third coloumn with a measure were I calculate a percentage for the price compared to a total.
Percent = SUM('Report'[Price] )/Sum('Report'[Pris total antal])*100
@TommiL ,
You can try a measure like
Rolling 3 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-3,MONTH))
Rolling 3 before 2 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],eomonth(MAX('Date'[Date ]),-1),-3,MONTH))
Thank you for the very quick reply.
I have tried that exact formula, but it seems more like it is summarizing instead of the average, so I can divide it by 3 so I have the average that could work.
But to make it more user friendly I have done the same measure on the Totalprice. Then I would like to have 3_Months_Price as a percentage of 3_months_totalPris. This I can't figure out as well. It doesn't seem possible to do as the other Percent I did.
I guess method are different when it want to do calculation of measures?
User | Count |
---|---|
98 | |
91 | |
84 | |
72 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |