Forum Discussion
Editing data in your current data model
I have a table which holds payment types. The types are only abbreviated in my model as C(cash) and D(debit order). I want to change the data to actaully show Cash and Debit order. So that my visual...
Hi Anonymous ,
You can add two new custom cloumns in the query edit.
Then remove the "C" and "D" columns, click "Close & Apply".
This method will not change the data in the DB and will not affect the next refresh.
If you are allowed to change it in power query (this will not change on your database),
just hit replace values.
If you want in dax,
Add calculated column like
Description of Code =
if (column name) = ("your code"), ("new description"),
if (column name) = ("your code"), ("new description1"))
Then you can use your calculated column instead of the code.