Forum Discussion

FStettler's avatar
FStettler
Helper I
6 years ago

Comparing 2 dates not working

Hi guys!   I'm stuck in a very (apparently) simple but deadend problem.   I have a table f-PICK UPS where transactions are recorded within, where recording date is one of the main fields I want t...
Need Help
parry2k's avatar
parry2k
Super User
6 years ago

FStettler As a best practice, add date dimension in your model and use it for and time intelligence calculations. Once the date dimension is added, mark it as a date table on table tools.

https://perytus.com/2020/05/22/create-a-basic-date-table-in-your-data-model-for-time-intelligence-calculations/

 

Once you set a relationship between data and transaction table, you can simply add previous day measure as below

 

Previous Day = 
CALCULATE ( SUM ( Table[Amount] ), PREVIOUSDAY ( DateTable[Date] ) )

or

Previous Day = 
CALCULATE ( SUM ( Table[Amount] ), DATEADD ( DateTable[Date] ), -1, DAY )

 

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡