Forum Discussion

JawaharPrem6's avatar
JawaharPrem6
Helper I
3 years ago
Solved

Network Days Calculation for Power Bi

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

General Comment
Tips and Tricks
Tutorial Requests

2 Replies

    • JawaharPrem6's avatar
      JawaharPrem6
      Helper I
      3 years ago

      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