topic Re: How to get following(prior) 8 weeks of avg data qty in DAX in DAX Commands and Tips

How to get following(prior) 8 weeks of avg data qty in DAX

Srikantht — Wed, 20 Apr 2022 14:37:06 GMT

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?

Re: How to get following(prior) 8 weeks of avg data qty in DAX

johnt75 — Wed, 20 Apr 2022 15:51:07 GMT

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] )

Re: How to get following(prior) 8 weeks of avg data qty in DAX

Anonymous — Wed, 27 Apr 2022 07:06:46 GMT

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

Re: How to get following(prior) 8 weeks of avg data qty in DAX

Srikantht — Sun, 26 Jun 2022 04:01:07 GMT

Thank you its working