Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
58 |
User | Count |
---|---|
194 | |
111 | |
105 | |
79 | |
71 |