Forum Discussion
Cannot calculate rolling 6 week average
Hello all. I am fairly new to Power BI, but I have managed some basic things already. My problem at the moment is as follows: I am using the following tables: date table (date, iso_week, year, mo...
I've just watched another tutorial about creating rolling average measures.
Can it be the reason mine is not working is that my measure "RQ" has somehow no connection to a date so I can't use the average functions with dates because I am calculating the RQ value for each individual week?
Maybe I should step back and ask: how should I arrange my tables and measures so I can calculate a RQ for each order and then show for each week or month the number of orders, the RQ and the 6wAVRG RQ?