Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table visual with a date column and its configured to show the "Latest". I now need a column to show the datediff between the latest date and today. I can figure out the DateDiff bit, but not to check the latest date.
Thanks in advance.
Solved! Go to Solution.
Days Since Latest = DATEDIFF([Latest Date], TODAY(), DAY)
Replace [Latest Date] with the name of the measure you created to find the latest date.
This formula calculates the difference between the latest date and today in days. You can change the last argument in the DATEDIFF function to calculate the difference in a different unit of time, such as weeks or months as per your needs.
Let me know if this works for your scenerio and if you may need further assistance.
Days Since Latest = DATEDIFF([Latest Date], TODAY(), DAY)
Replace [Latest Date] with the name of the measure you created to find the latest date.
This formula calculates the difference between the latest date and today in days. You can change the last argument in the DATEDIFF function to calculate the difference in a different unit of time, such as weeks or months as per your needs.
Let me know if this works for your scenerio and if you may need further assistance.
Thanks, you're suggestions worked 👊
Its my pleasure - Do not hesitate to reach out, if you might have further questions 🙂
Latest Date = MAX('Table'[Date])
Replace 'Table'[Date] with the name of your date column.
Once you have the latest date, you can calculate the datediff between that date and today using the DATEDIFF function.
Hello @StuartSmith,
To calculate the datediff between the latest date and today in your table visual, you'll first need to determine what the latest date is. You can do this by using a measure that calculates the maximum date in the column.
User | Count |
---|---|
106 | |
89 | |
82 | |
76 | |
73 |
User | Count |
---|---|
112 | |
103 | |
96 | |
74 | |
67 |