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.
= Table.AddColumn( Source, "l_Holidays", each Table.Column(Table.SelectRows(Holiday, each Holiday[Country] = [Country]), "Date") )
Solved! Go to Solution.
I was able to make it work from my side and was able to add a couple more conditions in. Not exactly sure what went wrong though.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!
Mark your calendars and join us for our next Power BI Dev Camp!