Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Yesterdays Sales

Hi everyone,   I'm working with a dashboard where I want a card to display the sales from yesterday, without using a slicer.    What I have done so far is to insert the sales data into "Fields" f...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Try a measure like

     

    yesterday=CALCULATE(sum('order'[Qty]),'Date'[Date]= today()-1)

     

    This will work if you do not have date filter. If you have some date filter

     

    yesterday=CALCULATE(sum('order'[Qty]),filter(all('Date'),'Date'[Date]= today()-1))

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , Try a measure like

 

yesterday=CALCULATE(sum('order'[Qty]),'Date'[Date]= today()-1)

 

This will work if you do not have date filter. If you have some date filter

 

yesterday=CALCULATE(sum('order'[Qty]),filter(all('Date'),'Date'[Date]= today()-1))

APM's avatar
APM
Helper I
5 years ago

Hey amitchandak, this helped me a lot too.

 

I used the same formula to automatically pull yesterday's sales revenues. However, I also want to pull sales revenues from yesterday last year.

 

Is there an edit I can make to the formula to pull that date?

 

Thanks!