DAX SALES OF THE LAST X MONTHS

[ricardo_cvo]

I need to get the sales of the last 60 days using dax, could anyone help me?

I have tested several ways but without success.

Thank you

[v-huizhn-msft]

Hi @ricardo_cvo.

There is a similar thread for reference, please review: https://community.powerbi.com/t5/Desktop/Rolling-7-Dates-based-on-selected-date-in-dropdown/m-p/1344....

Best Regards,
Angelia

[Washivale · Accepted solution]

Hi,

you can try below:

last 60 days sales =Calculate(sum(Sales[amoujnt]),Sales[date]<=Today()-60)

Or 

last 60 days sales =Calculate(sum(Sales[amoujnt]),Sales[date]<=Max(sales[date])-60)