Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi Teams,
I have 2 tables and I make the comparison between them. I added one more column called "Updated Comparation". If columns in NewData table is different from OldData table, then "Updated Comparation" will update the NewData[Last Updated] values.
2 first rows the information is different so "Updatad Comparation" show the value. Since FirstNames are different from 2 tables, now I want to replace the FirstNames from Olddata by NewData. (ken => kenneth, bob => robert)
My code so far is bellow. How to I replace the values of FirstNames? Tks
Solved! Go to Solution.
HI, @Anonymous
Do you mean that you want to update the data in the original data column?
If so, you could not get it in power bi for now.
You could create the new column as amitchandak said, or use the same logic to create a New table.
Regards,
Lin
HI, @Anonymous
Do you mean that you want to update the data in the original data column?
If so, you could not get it in power bi for now.
You could create the new column as amitchandak said, or use the same logic to create a New table.
Regards,
Lin
Try creating columns like this and then use them in calculation
Max customer = MAXX(filter(Sales,Sales[Order Id]='Item'[Max Sales order id] && Sales[item_id]='Item'[Item ID]),Sales[Customer ID])
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks.
My Recent Blog - https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
User | Count |
---|---|
88 | |
88 | |
74 | |
69 | |
57 |
User | Count |
---|---|
136 | |
110 | |
91 | |
84 | |
69 |