Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have this data with the products and their respective groups. However, the same product is part of two groups. In my case I have the product "FANTA GUARANA ZERO 2L 6UN" which is part of the groups "SABORES SA 2L" and "FANTA GUARANA 2L". I wanted the product "FANTA GUARANA ZERO 2L 6UN" to be part of the "SABORES SA 2L" GROUP. I Need distinct items for create a key.
It's possible?
Solved! Go to Solution.
If I understand your requirement correctly, you can concatenate the two columns and then remove duplicates based on that column.
Or you can create an index column based on your required column and do the further transformations accordingly
I hope one of these will work for you.
If I understand your requirement correctly, you can concatenate the two columns and then remove duplicates based on that column.
Or you can create an index column based on your required column and do the further transformations accordingly
I hope one of these will work for you.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
Check out the May 2024 Power BI update to learn about new features.