Forum Discussion
Solved
Creating a 'Days Past Due' Column
Hi everyone, I have a date column (due date) and I want to create two additional columns: Calculates the number of work days (Mon-Fri) past the due date (assuming it is past due) Calculates...
Hi nathanisaacson ,
The following DAX might work for you:
Work Days Past Due = VAR Currentday = TODAY() RETURN IF('Table'[Due Date] > Currentday, NETWORKDAYS(Currentday, 'Table'[Due Date], 1), BLANK())Work Days Until Due = VAR Currentday = TODAY() RETURN IF('Table'[Due Date] < Currentday, NETWORKDAYS('Table'[Due Date], Currentday, 1), BLANK())I will show you when is it today by using this DAX:
Currentday = TODAY()And the final output is shown in the following figure:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi nathanisaacson ,
The following DAX might work for you:
Work Days Past Due =
VAR Currentday = TODAY()
RETURN
IF('Table'[Due Date] > Currentday,
NETWORKDAYS(Currentday, 'Table'[Due Date], 1), BLANK())Work Days Until Due =
VAR Currentday = TODAY()
RETURN
IF('Table'[Due Date] < Currentday,
NETWORKDAYS('Table'[Due Date], Currentday, 1), BLANK())I will show you when is it today by using this DAX:
Currentday = TODAY()
And the final output is shown in the following figure:
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Oh, sorry I got the names of the two calculated columns reversed, but the functionality is normal.