topic Re: Dax Function retrieve value from previous entry in DAX Commands and Tips

Dax Function retrieve value from previous entry

PhilippMer — Fri, 10 Jun 2022 06:55:42 GMT

Hello, I have come across a problem, and im not able to find the right expression in DAX to solve it so far.

I have a Table with Data from a LinkedIn profile, there are over 90 different Posts and the corresponding amount of Views on every single day. I would like a Column to have the the Value of the amount of Views from the previews day, so that I can make a simple Calculation of how many new Views per day each post had. My table looks like the following:

I tried going through the LogDate with Earlier...but so far had no success. There is no ID only the PostText as a String. Any recommendations on how I could get to the solution?

Thanks in advance!

Re: Dax Function retrieve value from previous entry

tamerj1 — Fri, 10 Jun 2022 07:06:46 GMT

Hi PhilippMer

please use

Previous Day Views = VAR CurrentDate = TableName[LogDate] VAR PostTable = CALCULATETABLE ( TableName, ALLEXCEPT ( TableName, TableName[PostText] ) ) VAR PreviousDate = MAXX ( FILTER ( PostTable, TableName[LogDate] < CurrentDate ), TableName[LogDate] ) RETURN MAXX ( FILTER ( PostTable, TableName[LogDate] < PreviousDate ), TableName[PostViews] )

Re: Dax Function retrieve value from previous entry

PhilippMer — Fri, 10 Jun 2022 07:14:42 GMT

Hi tamerj1

thank you so much for your quick reply. The formula almost works as expected. I think for some reason it takes the Numbers 2 entries from before and not the first entrie before of the current date.

Screenshot:

Do you know why this is happening?

Re: Dax Function retrieve value from previous entry

tamerj1 — Fri, 10 Jun 2022 07:31:41 GMT

PhilippMer

Sorry my mistake

Re: Dax Function retrieve value from previous entry

PhilippMer — Fri, 10 Jun 2022 07:36:27 GMT

Thank you tamerj1 you saved my day!