Please help me on achiving below scenario
Hi newellaa ,Thanks for the quick reply, you are in the right direction.
Hi @shafeeqva ,
The Table data is shown below:
Please follow these steps:
1.Create relationships between tables
2.Use the following DAX expression to create a column
Column = RELATED(City[City])RELATED function (DAX) - DAX | Microsoft Learn
3.Final output
Best Regards,
Wenbin Zhou
Hi newellaa ,Thanks for the quick reply, you are in the right direction.
Hi @shafeeqva ,
The Table data is shown below:
Please follow these steps:
1.Create relationships between tables
2.Use the following DAX expression to create a column
Column = RELATED(City[City])RELATED function (DAX) - DAX | Microsoft Learn
3.Final output
Best Regards,
Wenbin Zhou
From the model view in Power BI desktop you could create a join between the city and country tables on city.
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
