Forum Discussion
Time calculations
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
3 Replies
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
