Lookupvalue from Date table and Return Holidays

[Anonymous]

Hi,

I have date table and holidays table. I've created calculated holiday column in date table to return holiday name from holidays table but I get error "A table of mulitple values was supplied where a single value was expected"

The holidays table includes 3 years of holidays so how do I return correct holiday for the corresponding year?

Holiday = LOOKUPVALUE('Holidays 2021-2023'[Holiday ],'Holidays 2021-2023'[Date],'Calendar'[Date])

[Jihwan_Kim]

Hi,

In a calculated column in the date table, for instance, on 29th/Nov/2021, what holiday name do you want to show?

I can see that your holiday table has two different holiday names on 29th/Nov/2021, and also, some of the dates have two different holiday names on the same date.

[Anonymous]

@Jihwan_Kim  those holidays are for different regions of the country i.e. where holiday name has "Anniversary" in the suffix. Do I need to separate these "anniversary" holidays into a separate table?

[wdx223_Daniel]

it seems there are duplicate dates in the table of holidays.

[Anonymous]

@wdx223_Danielyes there are because I have future holidays included in the table. How do I factor this into the measure to return holiday column based on the corresponding year date?

[wdx223_Daniel · Accepted solution]

try this

Calculated Column=concatenatex(filter(holidays_table,holidays_table[date]=calendar[date]),holidays_table[holiday],",")

[Anonymous]

@wdx223_Daniel  perfect that worked, thank you. Much appreciated.