Highest value of a "moving 30 days sum measure" over time

[sfanget]

Hello all,

I have a table with basically the following columns :
- POS ID

- Reference ID
- Date
- Daily Sales

I have created a "moving 30 days sales" measure with this formula :

30daysSales =
CALCULATE(

SUM(Table[Daily Sales])

, DATESINPERIOD(Table[Date], MAX(Table[Date]), -30,DAY)

)

Now I try to get the highest value of this "30daysSales" over the time horizon for each POS & Reference

MAXX(Table, [30daysSales])

does not fullfill my hope !

Any help appreciated

[sfanget]

Hello
Thanks for your time.

Unfortunately, as mentionned, a simple MAXX does not do the trick.

If I filter the table to latest 30 days, it gives the latest value of the measure, not the highest of all time horizon

[sfanget · Accepted solution]

MAXX(

    KEEPFILTERS(VALUES('Calendar'[Date])),

    CALCULATE(30daysSales)

)
Does the trick !

[ribisht17]

@sfanget 

MAXX(Table, [30daysSales])

Filter this Table to Last 30 Days and then Find the max of Sales

Something like this https://docs.microsoft.com/en-us/dax/maxx-function-dax

Thanks,

Ritesh

Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My YT Channel Dancing With Data !! Connect on Linkedin !!Power BI for Tableau Users