Editing data in your current data model

[Anonymous]

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 visualisation holds the full description for users to understand.

Can this be achieved without having to change the data in the db? And how?

[v-eachen-msft · Accepted solution]

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.

[mussaenda]

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.

[MatejZukovic]

Hi @Anonymous ,

if you don't want to modify your source table you can create a mapping table with two columns - first with abbreviation and second with full description. 

Then you can create relationship between the two tables and use field containing full description in your dashboard.

Hope it helps!

Matej