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.
Hello,
I have a challenge and i hope, somewere can help me.
We can i created this table i Power Query or in DAX?
25 | 43000 | 25 | 43000;45000;85000;1588 | |
25 | 45000 | 26 | 999;858;4786;4587 | |
25 | 85000 | |||
25 | 1588 | |||
26 | 999 | |||
26 | 858 | |||
26 | 4786 | |||
26 | 4587 |
Many Thanks for the Help!
Best Regards,
Simon
Solved! Go to Solution.
If you are looking to concatenate the values then the below should help in dax as a measure:
with Power Query
=Table.Group(YourSource, {"Column1"}, {{"Combine", each Text.Combine([Column2], ";"), type text}})
Stéphane
If you are looking to concatenate the values then the below should help in dax as a measure:
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.