Today and Yesterday Totals

[Anonymous]

Hello Community -  I have tried this measure below, but it gives me YTD values.   What I want is just today, specifically.    

So, for example if we shipped 500,000 dollars YTD....but today we just shipped 25,000....I want the card visual to say $25,000

Today Net Shipped Revenue = CALCULATE(SUM(ShippedOrdersALL_Query[ShippedPrice]),FILTER('Date Table',TODAY()))

Likewise for yesterday.   I tried using PreviousDay, but the only way it gives me the correct value is if I am filtered down on a visual that shows today's date.   Then, the card visual shows me the correct value for Yesterday.    But not what I am looking for.  I need the card visual to always show the specifical value for yesterday's shipments, regardless of any other filters applied on the page.   Thanks Community!

Shipments Yesterday = CALCULATE(SUM(ShippedOrdersALL_Query[ShippedPrice]),PREVIOUSDAY('Date Table'[Date]))

[Greg_Deckler · Accepted solution]

@Anonymous I would keep it simple:

Today Net Shipped Revenue = CALCULATE(SUM(ShippedOrdersALL_Query[ShippedPrice]),'Date Table'[Date] = TODAY())

Today Net Shipped Revenue = CALCULATE(SUM(ShippedOrdersALL_Query[ShippedPrice]),'Date Table'[Date] = TODAY()-1)

[Anonymous]

Thank You @Greg_Deckler    Worked perfectly.

[selimovd]

Hey @Anonymous ,

why don't you use DATEDD with -1 DAY from TODAY(). Like this you should get the value from yesterday.

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic