return text based off calender date

Anonymous, this is a fairly standard problem. The way to solve it would be to create a Date dimension in your Power BI report. The Date dimension can have a column (e.g. IsWorkingDay) that indicates is a day is a working day or not. How you populate that column will depend on the needs of your solution. Having a Date dimension in place will make it easier to do many other time-based calculations.

Once you have created a Date dimension, you can then add a Calculated Column to your source data to work out what the DueStatus for each row is. The logic in this calculation will use today's date, the DueDate, and the Date dimension's IsWorkingDay flag to produce the Past Due, Due Today, Due in Two Days, On Track, or whichever other statuses are needed.

A basic demonstration of the Calculated Column, without using a Date dimension, is shown below.

DueStatus = 
    VAR daysdiff = DATEDIFF(TODAY(), YourTable[DueDate], DAY)
    RETURN
    SWITCH(TRUE(),
        daysdiff < 0, "Past Due",
        daysdiff = 0, "Due Today",
        daysdiff <= 2, "Due in Two Days",
        "On Track"
    )

I am using  this test data for YourTable:

And this is the output:

Is this the sort of thing you are looking for?

Anonymous, further to my first reply, I have created a solution which takes working days into account.

Create a Date dimension table which has a WorkingDays column as an integer. For working days set this to 1, for non-working days set it to 0. In my example I used this data for October:

Date   WorkingDays

Then in your data table, create a Calculated Column called WorkingDaysTillDueDate with this DAX expression:

WorkingDaysTillDueDate = 
    VAR duedate = YourTable[DueDate]
    VAR today = TODAY()
    RETURN
        SWITCH(TRUE(),
            duedate = today, 0,
            duedate < today,
            CALCULATE(
                0 - SUM(dimDate[WorkingDays]),
                dimDate[Date] >= duedate,
                dimDate[Date] < today
            ),
            duedate > today,
            CALCULATE(
                SUM(dimDate[WorkingDays]),
                dimDate[Date] > today,
                dimDate[Date] <= duedate
            )
        )

Now create another Calculated Column called DueStatus with this DAX expression:

DueStatus = 
    VAR days = YourTable[WorkingDaysTillDueDate]
    RETURN
        SWITCH(TRUE(),
            days < 0, "Past Due",
            days = 0, "Due Today",
            days <= 2, "Due in Two Days",
            "On Track"
        )

When I run this today (25 Oct 2023) it gives me the following results for dates from 23 Oct to 30 Oct. And whenever you refresh the report, it will recalculate both Calculated Columns based on the current today's date.

You will need to maintain the dimDate table by populating it with any future dates and what the WorkingDays field should be for each.

Hopefully this helps.