Latest Enterprise DNA Initiatives

Averagex Moving Average calculation

I have the following measure…

AVERAGEX(
DATESINPERIOD(‘DateTable’[Date],
LASTDATE(‘DateTable’[Date],
-1, DAY), [Fulfilled Dollar %])

All I have to choose from is YEAR, QUARTER, MONTH, DAY. How can I modify the DAY selection to change it to WEEK? If I say…-7,DAY, like below, it will only compare what happen on the single day 7 days ago to today, right?

LASTDATE(‘DateTable’[Date],
-7, DAY), [Fulfilled Dollar %])

Hi @Usates,

You’ll need an attribute at that weekly granularity to iterate over, something like the “Week & Year” from your Date dimension table. Similar to the monthly avg. illustrated here.

I hope this is helpful.

1 Like

I can work with this. Thank you