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.
Hi All,
Very new (first post) to PowerBI, M and Dax.
I am trying to filter at data refresh the lines included in the data load based on whether a value in one column exists in another column in another table.
I have two tables, StatePostcode and Address. I have filtered the StatePostcode table to include only Victoria.
I now only want to load the rows in the Address table that relate to those Postcodes that exist in the StatePostcode table. Each table has a Postcode column so I want to load only the rows in the Address table in which the Postcode in that row exists in the Postcode column in the StatePostcode table
I have mangaed to achieve what I want by creating a distinct query list (Postcodes) from the StatePostcode table and using it in the below filter however it is extreamly slow to the point I cannot use it in any actual application, but it (eventually) works.
= Table.SelectRows(_address, each List.Contains(Postcodes,[Postcode]))
Can anyone provide me with a better method/filter to achieve the same?
Thanks for any help.
Solved! Go to Solution.
you are done
Hello @craigpowell ,
I think using parameters will filter your table according to the PostCode entered.
Please let me know if you want to use parameters and filter the table.
If you dont want to use parameters,I'm afraid this solution won't be used.
Thanks.
you are done
Cheers Matt.
Worked perfectly!
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 |
---|---|
107 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |