Forum Discussion
Using a mapping table to create new columns
I have a dataset with a bunch of tables, all have at least one column which contains a value e.g. 1000000006 which maps to a sensible label name e.g. 1000000006='Call Initiated'
I've pulled the mapping data into a table in PBI which looks like the attached image.
The Schema Name is the column title, and value is what is in the cells of that column, and Label is what I want my new column value to be. So I need to use 'Schema Name' as well as 'Value' because value by itself isn't unique.
How do I create a new column in my tables, which looks at the column title, and the value to give me my new label?
Hi Anonymous ,
In your scenario, we can create a calculated column with the CALCULATE() and FILTER() function like below:
calculate (min('mapping data'[label]),filter (all('mapping data'),'mapping data'[schema name] = "***" && 'mapping data'[value] = 'data table'[value]))Best Regards,
Teige
1 Reply
Hi Anonymous ,
In your scenario, we can create a calculated column with the CALCULATE() and FILTER() function like below:
calculate (min('mapping data'[label]),filter (all('mapping data'),'mapping data'[schema name] = "***" && 'mapping data'[value] = 'data table'[value]))Best Regards,
Teige