Dax Function retrieve value from previous entry

[PhilippMer]

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!

[tamerj1]

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

[PhilippMer]

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?

[tamerj1 · Accepted solution]

@PhilippMer 

Sorry my mistake 

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

[PhilippMer]

Thank you @tamerj1 you saved my day!