Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I have managed to calculate if the day is a working day or not, but I need another column for each transaction to show the number of working days. Instead of '1', I need it to calculate it as 23. For Example, 15th January 2018 in one column and the another column 23
Any help will be greatly appreciated.
SJ
Solved! Go to Solution.
Hi @Anonymous,
Calculated column.
WorkingDay = IF(WEEKDAY('Date table'[Date],2)<=5,1,0)
Measure.
count workingdays = CALCULATE ( SUM ( 'Date table'[WorkingDay] ), ALLEXCEPT ( 'Date table', 'Date table'[Date].[Year], 'Date table'[Date].[Month] ) )
Best regards,
Yuliana Gu
Hi @Anonymous,
Calculated column.
WorkingDay = IF(WEEKDAY('Date table'[Date],2)<=5,1,0)
Measure.
count workingdays = CALCULATE ( SUM ( 'Date table'[WorkingDay] ), ALLEXCEPT ( 'Date table', 'Date table'[Date].[Year], 'Date table'[Date].[Month] ) )
Best regards,
Yuliana Gu
Thank you very much! That is exactly what I needed!
Thank you,
SJ
User | Count |
---|---|
139 | |
113 | |
103 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |