Forum Discussion

ricardo_cvo's avatar
ricardo_cvo
Icon for Helper I rankHelper I
8 years ago
Solved

DAX SALES OF THE LAST X MONTHS

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
General Comment
  • Washivale's avatar
    Washivale
    8 years ago

    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)

Washivale's avatar
Washivale
Icon for Resolver V rankResolver V
8 years ago

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)