Forum Discussion
Calculate working days between 2 dates
Hi All, I was trying for long time and couldn’t break this through. I was trying to get the “networkdays” in excel equivalent at PowerBI. After rounds of searching online, I believe the below s...
Found the solution, after looking at all the threads. simply mistake = don't use New Measure, use New Column
Apologoies. Allowed me to elaborate. I have a column (consist of 30k+) of transaction created date, resolved date. I want to calculate the working days between these 2 dates. May I know what is the best way to calculate working days? (I don't need to involve Public Holidays).
My current formula as such
CALCULATE(SUM(Calendar_Updated[Work/NonWowrk Day]),DATESBETWEEN(Calendar_Updated[Date],('KPI'[Created Date Time],'KPI'[stat_DateTime Resolved]))
Found the solution, after looking at all the threads. simply mistake = don't use New Measure, use New Column