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.

  • 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
      Icon for Community Support rankCommunity 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.