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,
I have a teble from which i want to replace a cell value with new one, let say
a raplace with B
C raplace with D
i have a table with those details where old and new
please help me how we can do this with query editor
Thanks
Solved! Go to Solution.
If so, you could try this simple way to get it:
Basic data:
Step1:
Merge table with that replacedetail table
Step2:
Expand the column
Step3:
Add a custom comndition column
Step4:
Now remove Type and After column, Rename this new custom column:
and here is sample pbix file, please try it.
Regards,
Lin
In query editor, right click on your cell value and select "Replace Values".
If multiple replacements are required, right click on your column and select "Replace Values".
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
If so, you could try this simple way to get it:
Basic data:
Step1:
Merge table with that replacedetail table
Step2:
Expand the column
Step3:
Add a custom comndition column
Step4:
Now remove Type and After column, Rename this new custom column:
and here is sample pbix file, please try it.
Regards,
Lin
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |