Network Days Calculation for Power Bi

[JawaharPrem6]

Hi All,

I have to calculate only for working days know as

"Rec Date"=02/28/2023 9:53 PM, 

Comp Date"=02/29/2023 9:53 PM

But it exclude Saturday and Sunday its work in Power Bi.

Thanks

Jawahar

[Idrissshatila · Accepted solution]

Hello @JawaharPrem6 ,

check this video , it helped me with the same case as yours https://youtu.be/6JA6uy3ZRBA

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[JawaharPrem6]

Hi,

Thanks for share the link, its working but in my data table mentioned 2 date columns are text, hence max value is not supporting can you help on same.

ProcessTime = 
var _Start = 'Gobal_Master_Data_EU (3)'[Received_Date]
var _End = 'Gobal_Master_Data_EU (3)'[Completed_Date]
Return SUMX(
    CALCULATETABLE(
        Calendar_Table,
        DATESBETWEEN(Calendar_Table[Date],_Start,_End),
        Calendar_Table[workday]=1
    ),
    MAX(MIN(Calendar_Table[TimeEnd],_End) - MAX(Calendar_Table[TimeStart],_Start),0)*24
)

Thanks