11-05-2018 02:32 PM - edited 11-05-2018 02:54 PM
See link above for sample calendar that is calculating working days.
The Matrix visual demonstrates that my method of determining a working day less holidays if functionally working. Example first day of the year is New Years Day which falls on a Monday, which would normally be a working day, however because it is a holday the matrix is showing as Zero for the first Monday of the year and a One for the second Monday of the year. So determining a working day minus holidays is working in my Power BI sample.
However, when I create a Month Name as the filter context and count rows that are working days
Count working days = CALCULATE(COUNTROWS(dates),FILTER(dates,dates[isworkingday]=1))
the table filter context is not working, instead of the actual days of work per month, it is showing 255 days.
I'm a newbie to Power BI, excuse me if the answer is simple, but not obvious to me, need help
Solved! Go to Solution.
11-05-2018 05:59 PM - edited 11-05-2018 06:00 PM
Never thought to simply use SUM. Normal thought process is towards counting the working days, but since each true workinday is represented by a 1 and non working days represented by 0, then using SUM works. Thank you.