difference between current time and datetime column excluding weekend

[sanjanarama]

I wanted result in days and hours format where result is ----- difference of current date time and create date time column , excluding weekend

create date/time	result
3/3/22 4:20 AM	6 days 7 hours
4/3/22 2:16 AM	5 days 7 hours
5/4/22 11:20 AM	4 days 7 hours
6/4/22 4:20 AM	3 days 7 hours
7/4/22 4:20 AM	2 days 7 hours

[v-chenwuz-msft · Accepted solution]

Hi @sanjanarama ,

Try this expression:

assum today is 2022.3.15 =
VAR _today =
    DATE ( 2022, 3, 15 )
VAR _workday =
    COUNTROWS (
        FILTER ( CALENDAR ( [create date/time], _today ), WEEKDAY ( [Date], 2 ) < 6 )
    )
VAR _time_hour =
    DATEDIFF ( [create date/time].[Date], [create date/time], HOUR )
RETURN
    _workday & " days " & _time_hour & " hours"

result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rocky09]

You can Check this link from Radacad
https://radacad.com/calculate-duration-in-days-hours-minutes-and-seconds-dynamically-in-power-bi-usi...