Forum Discussion
Helper IIIBest Method to Transform Codes to Meaningful Data
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
Helper IIII'm creating the lists as I come across them. I have to research what the letters are and what they correspond to as I come across each column in each table that has such a list. There are many such columns with independent lists of what the letters mean and unfortunately the letters are reused. So for example, in a Status column, I=Inactive, and in a Type column, it might be I=Inventory Control.
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
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.