Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Example
Solved! Go to Solution.
Please check if this article helps
http://www.excelnaccess.com/count-only-working-days-between-2-dates/
Count Business Days = VAR MyDates = ADDCOLUMNS ( GENERATESERIES ( TableName[StartDate] + 1, TableName[ EndDate] ), "Day", WEEKDAY ( [Value], 2 ) ) RETURN COUNTROWS ( FILTER ( mydates, [Day] <= 5 ) )
Please check if this article helps
http://www.excelnaccess.com/count-only-working-days-between-2-dates/
Count Business Days = VAR MyDates = ADDCOLUMNS ( GENERATESERIES ( TableName[StartDate] + 1, TableName[ EndDate] ), "Day", WEEKDAY ( [Value], 2 ) ) RETURN COUNTROWS ( FILTER ( mydates, [Day] <= 5 ) )
Perfect thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |