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/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

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.

5 Replies

    • PatriceGREN's avatar
      PatriceGREN
      Regular Visitor
      6 years ago

      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's avatar
        v-lionel-msft
        Community Support
        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
    Community 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