Forum Discussion
Please help me on achiving below scenario
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
2 Replies
From the model view in Power BI desktop you could create a join between the city and country tables on city.
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
