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 tod...
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)
     
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!

     

    • 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!