Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi,
I have a Calendar table and a complaints table. I am wanting to work out the days between when workday is 1 and bank holiday is 0 - how can I do this - tried a few things but cant seem to get it to work
example
Date | Is Workday | Bank Holiday |
25/02/2024 | 1 | 0 |
26/02/2024 | 1 | 0 |
27/02/2024 | 0
| 1 |
I also have a complaints table
Date Raised | Initial Response |
25/02/2024 | 28/02/2024 |
Solved! Go to Solution.
@jak8282 , You can use networkdays, you can also pass holiday list as table to this function
networkdays([Start Date], [End Date], 1)
refer how to use calendar for holiday
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
Thanks @amitchandak that looks good - i managed to get it working by using
BusinessDaysCount =
VAR originalDate = 'Complaints'[Original Date of Complaint]
VAR closedDate = 'Complaints'[Initial closed date]
RETURN
CALCULATE(
COUNT('Calendar Date'[date]),
FILTER(
ALL('Calendar Date'),
'Calendar Date'[date] >= originalDate &&
'Calendar Date'[date] <= closedDate &&
'Calendar Date'[Bank Holidays] = 0 &&
'Calendar Date'[Is Weekday] = 1
)
)-1
@jak8282 , You can use networkdays, you can also pass holiday list as table to this function
networkdays([Start Date], [End Date], 1)
refer how to use calendar for holiday
Power BI - Business day with and without using DAX Function NETWORKDAYS: https://www.youtube.com/watch?v=Qs03ZZXXE_c
https://medium.com/@amitchandak/power-bi-dax-function-networkdays-5c8e4aca38c
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |