Create holiday chart - The expression refers to multiple columns...

Hi PowerBIsv,

SUMMARIZE function will generate a table, you can't direct use this function in calculated column.

SUMMARIZE Function (DAX)

Returns a summary table for the requested totals over a set of groups.

For your requirement, I'd like to suggest you to create the expand table to stored the detail holiday range, then create relationship with calendar table and build visual on these columns.

Table formula:

Holiday Schedule = 
    SUMMARIZE (
        FILTER (
            CROSSJOIN ( HolidayTable, 'Calendar' ),
            [Date] >= [Start Date]
                && [Date] <= [End Date]
        ),
        [Name],
        [Date],
        [Qualification]
    )

Result:

Regards,

Xiaoxin Sheng