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.
Hi,
I'm searching for a smart way to pick the right value from a configuration file.
I have a table where I want to assign a certain value in a calculated column "Profile" based on the values in some of the other columns.
Here is an example table named "Issues":
I would like to compare the values in "Category 1", "Category 2" and "Category 3" with the value in the configuration table name "Profiles" if there is an exact match in "Category 1, "Category 2" and "Category 3" I want this value from the Profiles[Name] to appear in the calculated column named Issues[Profile]
Here is a example table named "Profiles":
i would like to be able to extent the number of Categories quiet easy.
Any suggestion is appriciated.
Solved! Go to Solution.
Hi You can achieve this using one step process of merging two queries in Query Mode. You can see in attached screenshots.
Thanks & Regards,
Bhavesh
Hi You can achieve this using one step process of merging two queries in Query Mode. You can see in attached screenshots.
Thanks & Regards,
Bhavesh
Hi Bhavesh,
Briliant, simple and neat just what I needed, thanks
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |