Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hiya,
I am connected to two tables via direct query, and both contain some geographic data. Below sample screenshot shows the tables:
also, the model is simple like the below:
My ask is to create a new virtual table with DAX (not PQ), where Table1[zip code] = Tbale2[zip code] and return these columns:
City, lat, long, zip, State and country.
Thanks
Sample file
Solved! Go to Solution.
You could add a new table like
Combined table =
GENERATE(
'Table1',
SELECTCOLUMNS(
FILTER( 'Table2', 'Table2'[Zip Code] = 'Table1'[Zip Code] ),
"State", 'Table2'[State],
"Country", 'Table2'[Country]
)
)
You could add a new table like
Combined table =
GENERATE(
'Table1',
SELECTCOLUMNS(
FILTER( 'Table2', 'Table2'[Zip Code] = 'Table1'[Zip Code] ),
"State", 'Table2'[State],
"Country", 'Table2'[Country]
)
)
Thank you very much.
User | Count |
---|---|
20 | |
18 | |
17 | |
11 | |
7 |
User | Count |
---|---|
28 | |
27 | |
13 | |
12 | |
12 |