Date difference for working days excluding sundays

Hi labuser1235, sounds like an if formula is needed here.

https://docs.microsoft.com/en-us/dax/if-function-dax

=if ( datediff ([StartDate],[EndDate],HOUR) < 24, "Less Than 24 Hours",
if (datediff ([StartDate],[EndDate],HOUR)>=24 and datediff ([StartDate],[EndDate],HOUR)<48,"24-48 Hours",
if (datediff ([StartDate],[EndDate],HOUR)>=48 and datediff ([StartDate],[EndDate],HOUR)<72,"48-72 Hours","More Than 72 Hours")

Alternatively you could change the datediff to days, which would return whole integers (0,1,2,3 etc) that could be used in a SWITCH function. you can read more, here;

https://docs.microsoft.com/en-us/dax/switch-function-dax

Does that help?

I've just realised you want Sundays excluded also. Do you have a Date Dimensions table in use?

If so, you can add an additional column, IsWeekDay, using the SWITCH function;

IsWeekDay =
SWITCH (
    WEEKDAY ( [Date] ),
    1, 0,
    1
)

 This basically says if weekday is 1 (Sunday) then 0 (false), else 1 (True), which can be referenced in a second measure;

=
CALCULATE (
    SUM ( DateTable[IsWorkday] ),
    DATESBETWEEN (
        DateTable[Date],
        'Source'[StartDate],
        'Source'[EndDate]
    )
)

Finally, this can be referenced in the original If formula or a new SWITCH to convert the integers into your string for binning.

I hope that helps a little more for you.