Newbiew - Time intelligence - holliday table

DennisSchlein , Create a measure like

Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR([LM_FirstScan],[CMR_Closed]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))
- countx(filter(Holiday,Holiday[Country] = table[Country] && table[Date] >= [LM_FirstScan] && table[Date] <= [CMR_Closed]),Holiday[Country])
Work Day = COUNTROWS(FILTER(ADDCOLUMNS(CALENDAR([LM_FirstScan],[CMR_Closed]),"WorkDay", if(WEEKDAY([Date],2) <6,1,0)),[WorkDay] =1))
- countx(filter(Holiday,Holiday[Country] = table[Country] && table[Date] >= [LM_FirstScan] && table[Date] <= [CMR_Closed]),Holiday[Country])

or

Work Day = datediff(LM_FirstScan],[CMR_Closed], day) +1 
- countx(filter(Holiday,Holiday[Country] = table[Country] && table[Date] >= [LM_FirstScan] && table[Date] <= [CMR_Closed]),Holiday[Country])

Hi DennisSchlein ,

I change your code for DateTable as this:

DateTable = 
FILTER(
ADDCOLUMNS (
    CALENDARAUTO(),
    "Year", YEAR ( [Date] ),
    "Month", FORMAT ( [Date], "mmmm" ),
    "Month number", MONTH ( [Date] ),
    "Quater", FORMAT ( [Date], "\QQ"),
    "Week", WEEKNUM( [Date], 2),
    "Day", DAY ( [Date] )
    
),
WEEKDAY([Date],2)<6 && not([Date] in VALUES(HOLIDAYS[DATE])))

Pbix in the end you can refer, if i misunderstood you please let me know.

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.