Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |