Time calculations

[Anonymous]

Hi,

I'm currently trying to copy a statement accross from Excel to DAX. The Excel one reads as below. The result outputs in h:mm in Excel.

(NETWORKDAYS([New End Date],BankHolidays)-1)*10/24)+([End Time]-CoreHourStart)),

DAX:

CALCULATE(SUM(vwDimDate[WorkingDayFlag]), DATESBETWEEN(vwDimDate[Date],MAX('Booking Scenarios'[New Start Date]), MAX('Booking Scenarios'[New End Date])))-1*10/24 + MAX(End Time, - TIME(8,0,0).

Could somebody please help me with this measure? Its currently working out the networks days, but not the second part.

Thanks in advance

Liam

[Anonymous]

Hi @Anonymous ,

The formula is abstract. It's better to share some sample data and expected out put to us.

Best Regards,

Jay

[amitchandak]

@Anonymous , refer

https://www.youtube.com/watch?v=9M1V_m-oEzc&vl=en

https://community.powerbi.com/t5/Desktop/NETWORKDAYS-type-function-in-PowerBI/td-p/154902

or refer to this file second page

https://community.powerbi.com/t5/Desktop/NETWORKDAYS-type-function-in-PowerBI/td-p/154902

[Anonymous]

Hi @amitchandak ,

Thanks for your reply. 

The network days isnt the part thats incorrect. It was the second part of converting to time and then multiplying.

)))-1*10/24 + MAX(End Time, - TIME(8,0,0).   

Thanks