Using PreviousDay

[PatriceGREN]

Hi,

I have a HISTORY table which contains 1 row per day with a repeated dataset until they change.
I'm looking for the syntax that will give me (according to the attached example)

4854 7/01/2020 20 and previous coefficient 15

I arrive at 4854 7/01/2020 20 but not the last data (15).

Thank you for your help,
Patrice

[v-lionel-msft]

Hi @PatriceGREN ,

Please create two measures.

Next_co = 
VAR Next_co = 
CALCULATE(
    MAX(Sheet1[Coefficient]),
    FILTER(
        ALLSELECTED(Sheet1),
        Sheet1[ID] = MAX(Sheet1[ID]) && Sheet1[Date] = MAX(Sheet1[Date]) - 1
    )
)
RETURN
Next_co

Changed Date = 
IF(
    MAX([Coefficient]) <> [Next_co] && [Next_co] <> BLANK(),
    MAX([Date])
)

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PatriceGREN]

Hello and thank you,
When I try to put a filter on "Changed Date" to only show the changes, it doesn't display anything. In addition, I tried to make a difference between "Coefficient" and Nextco to know the amount of the increase.
I admit that the syntax I do not quite understand it, for that it does not work exactly with what I do

[Greg_Deckler]

@PatriceGREN - So funny, I just wrote a Quick Measure that includes PREVIOUSDAY - To **bleep** with NEXTDAY - https://community.powerbi.com/t5/Quick-Measures-Gallery/To-bleep-With-NEXTDAY/td-p/1245497

[PatriceGREN]

Hello,
I will need a little time to understand these functions and especially to be able to use them 🙂
I will work on it, thank you

Patrice

[v-lionel-msft · Accepted solution]

Hi @PatriceGREN ,

Just need to modify the following code.

Please refer to my .pbix file.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.