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...
Quick update:
I changed the formula as follows:
Produced 6W =
CALCULATE(
AVERAGEX('DAX','DAX'[RQ]),
DATESINPERIOD(Dim_Datum[Date],LASTDATE(Dim_Datum[Date]),-42, DAY)
)This somehow gives me a calculated value of 7,69% - but its the same for all weeks.