Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi there
How to calculate number of working days for each month of the year, where
the current month have to show number of days between 1st day of month and NOW().
For the working dates I have additional column with indicator of where is working day or not.
Solved! Go to Solution.
Hi @mrslyfox,
Try this formula please:
MeasureSumWorkdays = CALCULATE ( SUM ( 'Calendar'[WorkingDay] ), FILTER ( 'Calendar', 'Calendar'[LINK_Date] <= TODAY () ) )
Best Regards!
Dale
Hi @mrslyfox,
How do you want to show them up? As a Calculated column or a measure?
As a Calculated Column, you need a [Month] column:
TotalWorkdayPerMonth = CALCULATE ( COUNT ( DateTable[IsWorkday] ), FILTER ( ALLEXCEPT ( 'DateTable', DateTable[Month] ), 'DateTable'[IsWorkday] = 1 && 'DateTable'[Date] <= TODAY () ) )
As a measure, we can sum up indicator of workday directly due to it's 0 and 1.
MeasureSumWorkdays = CALCULATE ( SUM ( DateTable[IsWorkday] ), 'DateTable'[Date] <= TODAY () )
Best Regards!
Dale
Hi @mrslyfox,
Try this formula please:
MeasureSumWorkdays = CALCULATE ( SUM ( 'Calendar'[WorkingDay] ), FILTER ( 'Calendar', 'Calendar'[LINK_Date] <= TODAY () ) )
Best Regards!
Dale
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |