Forum Discussion
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...
If the timeframe key is from date table , you can try this.
Measure = DATEDIFF(max('Date'[Date]),today(),day)
If the timeframe key is from date table , you can try this.
Measure = DATEDIFF(max('Date'[Date]),today(),day)