Forum Discussion

Xaraja's avatar
Xaraja
Icon for Helper III rankHelper III
4 years ago
Solved

Best Method to Transform Codes to Meaningful Data

I am working with data that tends to have a lot single or double letter codes for which the meaning is not always obvious and which need to be transformed into what they mean before they are displaye...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Xaraja 

    For every column with codes, your best bet will be to create a separate DIM table.

    If you are not able to chage the dataset, then there may not be much that can be done.

    Regards,

    Pranit

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Xaraja 

For every column with codes, your best bet will be to create a separate DIM table.

If you are not able to chage the dataset, then there may not be much that can be done.

Regards,

Pranit

Xaraja's avatar
Xaraja
Icon for Helper III rankHelper III
4 years ago

A separate table in the dataset? Like I would create a tiny table in my dataset with two columns and five rows with the data from my original post? And then when building the report use the labels from that table instead of ever pulling them in as a column?

 

I can build the datasets however I want. What I cannot do currently is replace all these single and double letter codes in the original data source with the text that they stand for. That is, I cannot back up to before the data is pulled into Power BI and get rid of the problem entirely.