cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
olimilo
Helper V
Helper V

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.

 

= Table.AddColumn(
    Source,
    "l_Holidays",
    each Table.Column(Table.SelectRows(Holiday, each Holiday[Country] = [Country]),
    "Date")
)
1 ACCEPTED SOLUTION

Hello @olimilo 

 

I created a small example to test.

Seemingly it works

Please check the attached Excel file

 

flost.png


Regards
Zubair

Please try my custom visuals

View solution in original post

4 REPLIES 4
Zubair_Muhammad
Community Champion
Community Champion

@olimilo 

 

try this modification

 

= Table.AddColumn(
    Source,
    "l_Holidays",
    each let mycountry=[Country] in Table.Column(Table.SelectRows(Holiday, each [Country] = mycountry),
    "Date")
)

Regards
Zubair

Please try my custom visuals

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

 

flost.png


Regards
Zubair

Please try my custom visuals

View solution in original post

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.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.