Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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: