Forum Discussion

nathanisaacson's avatar
nathanisaacson
Frequent Visitor
2 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

     

nathanisaacson's avatar
nathanisaacson
Frequent Visitor
2 years ago

Hi JorgePinho ,

 

Thanks for the quick response!  I don't think that's exactly what I'm looking for.  I don't have a static end date - my end date is technically the current date (which would adjust automatically everyday, ideally).