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 m...
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
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