Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Hello @olimilo
I created a small example to test.
Seemingly it works
Please check the attached Excel file
try this modification
= Table.AddColumn( Source, "l_Holidays", each let mycountry=[Country] in Table.Column(Table.SelectRows(Holiday, each [Country] = mycountry), "Date") )
Hi @Zubair_Muhammad ,
I tried your edit and am still getting blank lists for each row. Do you know what could be the problem here?
Hello @olimilo
I created a small example to test.
Seemingly it works
Please check the attached Excel file
Thanks @Zubair_Muhammad
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |