Trying to create a filtered list from another table
I'm trying to create a column with a list of holidays (l_Holidays) for my main table (Source) using an existing Holiday table. But upon checking, it always returns an empty list (which should not be the case). Anyone know what I'm doing wrong here? The holiday list returned should be the holidays for that country.
each Table.Column(Table.SelectRows(Holiday, each Holiday[Country] = [Country]),