Forum Discussion
Anonymize money
Anonymous I can try to explain here, let's say your existing column is called Amount
- click transform data
- add custom column and call it New Amount
- add following expression for custom column, in your formula replace value with Amount column name. For example, in following expression I replace 3 with Amount.
=[Amount]*0.52+300/238*2.12- after new custom column is added, remove Amount column
- rename New Amount column to Amount
close and apply and it will load new data to the model.
PS - Make backup of your pbix before making these changes.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thanks parry2k , I thought so.
Do you maybe have an example of this? I am always at a loss in power query, have no clue where to start and how to do it.
Super UserAnonymous I can try to explain here, let's say your existing column is called Amount
- click transform data
- add custom column and call it New Amount
- add following expression for custom column, in your formula replace value with Amount column name. For example, in following expression I replace 3 with Amount.
=[Amount]*0.52+300/238*2.12
- after new custom column is added, remove Amount column
- rename New Amount column to Amount
close and apply and it will load new data to the model.
PS - Make backup of your pbix before making these changes.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Thanks parry2k exactly what I needed!