Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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 |
---|---|
124 | |
106 | |
99 | |
63 | |
59 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |