Forum Discussion

PatriceGREN's avatar
PatriceGREN
Regular Visitor
6 years ago
Solved

Using PreviousDay

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/...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    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.

v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

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's avatar
PatriceGREN
Regular Visitor
6 years ago

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