topic Re: DAX Help - Partially created from Time Intelligence in DAX Commands and Tips

DAX Help - Partially created from Time Intelligence

ScottBrown — Sat, 04 Dec 2021 22:15:38 GMT

I need filtering this down a little further,

Need to filter the weekIndex to be greater than or equal to -20
How do I round the answer = currently is 22.67 which is correct

AVG Weekly Production Last 20 Wks =

AVERAGEX(

KEEPFILTERS(VALUES('DimDates'[weekIndex])),

CALCULATE(COUNT('Production_Stock_OrderLines_HIST-PROD'[txtOrdNo])

))

Thnaks in Advance

Re: DAX Help - Partially created from Time Intelligence

AlexisOlson — Sat, 04 Dec 2021 22:25:49 GMT

Is this what you mean?

AVG Weekly Production Last 20 Wks = ROUND ( AVERAGEX ( FILTER ( VALUES ( 'DimDates'[weekIndex] ), 'DimDates'[weekIndex] >= -20 ), CALCULATE ( COUNT ( 'Production_Stock_OrderLines_HIST-PROD'[txtOrdNo] ) ) ), 0 )

Re: DAX Help - Partially created from Time Intelligence

ScottBrown — Sun, 05 Dec 2021 03:41:31 GMT

Thank You very much for the help.