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.
Could someone please hep to replace the values in editor
I have 2 tables
Table 1:
Id | Name |
1 | America |
2 | Australia |
3 | Denmark |
4 | India |
5 | China |
Table 2:
Id |
2 |
3 |
5 |
2 |
5 |
5 |
1 |
2 |
3 |
4 |
Now I want the Id's in Table 2 to be replaced in single shot with Name from Table 1 since I have 'n' number of rows in reality
Solved! Go to Solution.
Try this calculated column
Column = LOOKUPVALUE(Table1[Name],Table1[Id],Table2[Id])
Try this calculated column
Column = LOOKUPVALUE(Table1[Name],Table1[Id],Table2[Id])
Hi @mahra-in
I believe you can use Merge Queries from the Home Tab of the Query Editor to get Names beside each Table 2 ID.
Then you can delete the ID column
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 |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |