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" for the visual, I then suppose that I in some way should filter the visual in order for the card to display the sales figures from yesterday. Is any of you having a good solution to this?

 

I would really appriciate your help!

 

Best

 

 

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

3 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper 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!

    • APM's avatar
      APM
      Icon for Helper I rankHelper 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!