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
FStettler's avatar
FStettler
Helper I
6 years ago

Hi parry2k  thanks for your swift answer.

 

I've tried all that. I have my calendar table set up as date table, and the relationship made.

PREVIOUSDAY won't work as I don't need the immediate previous date like in a continuous calendar table. I need the previous date WITH DATA. In my example, some data was collected on 17/02/2020 and the next day where data was collected was 19/02/2020, and then the next one was 11/06/2020. This doesn't follow a pattern.

PREVIOUSDAY and DATEADD in your example are related to the immediate previous date, which is most likely to be blank in my model.

 

Thanks again.

Facundo

parry2k's avatar
parry2k
Super User
6 years ago

FStettler ok in that case try this

 

Prev Day = 
VAR __prevDate = CALCULATE ( MAX ( TransactionTable[Date] ), FILTER ( ALL ( DateTable[Date] ), DateTable[Date] < MAX ( DateTabble[Date] ) ) )

RETURN

CALCULATE ( SUM ( Table[Amount] ), DateTable[Date] = __prevDate )

 

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.⚡