Hello everyone,
I am trying to have in a column "WorkingDay(Month)" the consildated number of working days for a particular month.
My calendar is 2 years (day level).
I have succeded so far to have the number of working days by month but with no distinction between years...so for example April has 43 working days.
I don't know how to fix this...
My calculated column formula :
= IF (
Calendar [WorkingDay] = "Y" ;
COUNTAX (
FILTER(
Calendar; Calendar[FiscalMonthNumber] = EARLIER (Calendar[FiscalMonthNumber];1)
)
;Calendar[WorkingDay]
)
)
Thank you for your help
Arnaud
I am trying to have in a column "WorkingDay(Month)" the consildated number of working days for a particular month.
My calendar is 2 years (day level).
I have succeded so far to have the number of working days by month but with no distinction between years...so for example April has 43 working days.
I don't know how to fix this...
My calculated column formula :
= IF (
Calendar [WorkingDay] = "Y" ;
COUNTAX (
FILTER(
Calendar; Calendar[FiscalMonthNumber] = EARLIER (Calendar[FiscalMonthNumber];1)
)
;Calendar[WorkingDay]
)
)
Thank you for your help
Arnaud