Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello,
I'm using Power Pivot and I need to compute the average of N last values, here N = 28 and is based on index column. Basically, I want to have the 28 last values from MAX index to (MAX index - 28)
I tired this :
AVG 4 Last week new shoppers:=CALCULATE(AVERAGE(Sweden[New shoppers]);FILTER(Sweden; MAX(Sweden[Index]) && MAX(Sweden[Index]) - 5))
But even if i change the N value (28 to 5 for example), the average is the same...
Do you have any idea?
Solved! Go to Solution.
hi @GeoffreyLou
i tried with a simplified dataset:
ceated a measure with such code:
you can change 5 to 28 in your real case.
hi @GeoffreyLou
i tried with a simplified dataset:
ceated a measure with such code:
you can change 5 to 28 in your real case.
Working like a charm, many thanks !
User | Count |
---|---|
41 | |
27 | |
23 | |
19 | |
16 |
User | Count |
---|---|
55 | |
35 | |
21 | |
18 | |
15 |