Firstly appologies I am really new to power bi. I need to calculate the working days between two date in row. I have tried using DATEDIFF which works for calendar days but I wish to exclude weekwends
Go to Solution.
Please check if this article helps
Count Business Days =
VAR MyDates =
GENERATESERIES ( TableName[StartDate] + 1, TableName[ EndDate] ),
"Day", WEEKDAY ( [Value], 2 )
COUNTROWS ( FILTER ( mydates, [Day] <= 5 ) )
View solution in original post
Perfect thank you
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.