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))

Anonymous's avatar
Anonymous
Not applicable
5 years ago

It worked, thank you!