Yesterdays Sales

[Anonymous]

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

[amitchandak · Accepted solution]

@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]

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!

[Anonymous]

It worked, thank you!