Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
how to write a measure of average of following(coming) 8 weeks qty for the above data & I have week end date in calendar . can anyone help for solution?
Solved! Go to Solution.
Hi @Srikantht ,
I created some data:
Here are the steps you can follow:
Create measure.
Measure =
var _today=TODAY()
var _week=WEEKNUM(_today,1)
return
AVERAGEX(FILTER(ALL('Table'),'Table'[week]>=_week-8&&'Table'[week]<_week),[rand])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi @Srikantht ,
I created some data:
Here are the steps you can follow:
Create measure.
Measure =
var _today=TODAY()
var _week=WEEKNUM(_today,1)
return
AVERAGEX(FILTER(ALL('Table'),'Table'[week]>=_week-8&&'Table'[week]<_week),[rand])
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you its working
Assuming that Demand Quantity is a measure, you could try
Avg 8 weeks =
VAR currentEndWeek =
LOOKUPVALUE ( 'Date'[End of week], 'Date'[Date], TODAY () )
VAR finalEndWeek = currentEndWeek + 56
RETURN
AVERAGEX (
ADDCOLUMNS (
CALCULATETABLE (
VALUES ( 'Date'[End of week] ),
'Date'[End of week] >= currentEndWeek
&& 'Date'[End of week] <= finalEndWeek
),
"@val", [Demand Quantity]
),
[@val]
)
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |