Forum Discussion

JawaharPrem6's avatar
JawaharPrem6
Icon for Helper I rankHelper 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 ...
General Comment
Tips and Tricks
Tutorial Requests
  • JawaharPrem6's avatar
    JawaharPrem6
    Icon for Helper I rankHelper 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