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.
I have a data source where I need to add a new column to display a calculated value of how many days late an action is past the due date, but if not late, then to display nothing. Any ideas?
Example of existing column:
Contract Due Date
11/30/2019
3/30/2019
11/30/2018
1/19/2019
1/19/2018
I need to add a column that would show:
Days Late
0 or null
0 or null
19 (calculated as Today (12/19) minus 11/30)
0 or null
334 (calculated as Today (12/19 minus 1/19)
Solved! Go to Solution.
something like this
Days Late = MAX(TODAY()-Table[Contract Due Date],0)
if it's not overdue the TODAY() - Table[Contract Due Date] will return a negative number, which is always less than 0, If it will be overdue the number will be positive returning the correct value
something like this
Days Late = MAX(TODAY()-Table[Contract Due Date],0)
if it's not overdue the TODAY() - Table[Contract Due Date] will return a negative number, which is always less than 0, If it will be overdue the number will be positive returning the correct value
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.
User | Count |
---|---|
48 | |
24 | |
20 | |
14 | |
12 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
18 |