Forum Discussion

stoppm's avatar
stoppm
Frequent Visitor
1 year ago
Solved

Create a measure to dynamically subtract difference between today's date and date in table

Hi, I have a slicer on a page that allows a user to select the timeframe they want to see data for (month, week, day). If I have a value with a timestamp of today's date, I want my visual to show today's value when the user selects any of the options.

 

Currently, the value with today's date is just categorized as "day", because I can't figure out how to dynamically filter and get today's date to show for all 3 three timeframes.

 

Is there a measure I can write that could handle this? 

Need Help
  • ryan_mayu's avatar
    ryan_mayu
    1 year ago

    If the timeframe key is from date table , you can try this.

     

    Measure = DATEDIFF(max('Date'[Date]),today(),day)
     

5 Replies

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    1 year ago

    If the timeframe key is from date table , you can try this.

     

    Measure = DATEDIFF(max('Date'[Date]),today(),day)
     
  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi stoppm 

     

    Just basing on the description, ryan_mayu 's solution should work. Otherwise, please provide a workable sample data (not an image), your expected result from the same sample data and your reasoning behind. You may post a link to Excel or a sanitized copy of your PBIX stored in the cloud.

    • v-aatheeque's avatar
      v-aatheeque
      Community Support
      1 year ago

      Hi stoppm ,


      If our response addressed by the community member for your query, please mark it as Accept Answer and click Yes if you found it helpful.

      Should you have any further questions, feel free to reach out.
      Thank you for being a part of the Microsoft Fabric Community Forum!

      • v-aatheeque's avatar
        v-aatheeque
        Community Support
        1 year ago

        Hi stoppm ,

        We haven’t heard back from you regarding our previous response and wanted to check if your issue has been resolved.

        If it has, please consider clicking “Accept Answer” and “Yes” if you found the response helpful.
        If you still have any questions or need further assistance, feel free to let us know — we're happy to help!

        Thank you!