Reply
Frequent Visitor
Posts: 11
Registered: ‎08-14-2018
Accepted Solution

Calculating Working Days correctly, but filter context for Month not working

[ Edited ]

https://app.powerbi.com/view?r=eyJrIjoiOGE4ZWU5ZjgtYzJhOS00MjkyLTkwN2UtNmNmM2RjYmU4YWEwIiwidCI6ImI1Y...

 

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


Accepted Solutions
Highlighted
Member
Posts: 51
Registered: ‎05-30-2016

Re: Calculating Working Days correctly, but filter context for Month not working

Hi surfingjoe,

Try just using SUM.

 

Count working days = SUM(dates[isworkingday])

 

Tell us if works for you.

 

View solution in original post


All Replies
Highlighted
Member
Posts: 51
Registered: ‎05-30-2016

Re: Calculating Working Days correctly, but filter context for Month not working

Hi surfingjoe,

Try just using SUM.

 

Count working days = SUM(dates[isworkingday])

 

Tell us if works for you.

 

Frequent Visitor
Posts: 11
Registered: ‎08-14-2018

Re: Calculating Working Days correctly, but filter context for Month not working

[ Edited ]

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.