Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
I've two dates:
- DueDate
- Today
I want to know the number of days overdue
Any idea?
Thks
I believe that is:
DATEDIFF([DueDate],[Today],day)
https://msdn.microsoft.com/en-us/library/dn802538.aspx
For some weird reason, the DATEDIFF function returns an error when the number is negative (which it might be).
So you can patch that by doing = IFERROR(DATEDIFF([DueDate],[Today],day),-1)
Or try = [DueDate] - [Today] and format the column as int.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.