Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
ID | Sub ID | Sub Level |
1 | 1 | level 3 |
1 | 2 | level 2 |
2 | 3 | level 3 |
3 | 4 | level 3 |
3 | 5 | level 1 |
4 | 6 | level 3 |
5 | 7 | level 2 |
6 | 8 | level 2 |
Looking for DAX Expression to - create a comma separate column of "Sub Level" group by "ID"
For EX.
ID | Sub ID | Sub Level | New Column |
1 | 1 | level 3 | level 3, Level 2 |
1 | 2 | level 2 | level 3, Level 2 |
2 | 3 | level 3 | level 3 |
3 | 4 | level 3 | level 3, Level 1 |
3 | 5 | level 1 | level 3, Level 1 |
4 | 6 | level 3 | level 3 |
5 | 7 | level 2 | level 2 |
6 | 8 | level 2 | level 2 |
Thanks in Advance
Solved! Go to Solution.
@kampyy , A new column
concatenatex(Filter(Table, [ID] = earlier([ID]) ) , [Sub Level] )
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
Hi @kampyy ,
Made some edits, added separator parameter (",").
Column = CONCATENATEX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[Sub Level],",")
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
Hi @kampyy ,
Made some edits, added separator parameter (",").
Column = CONCATENATEX(FILTER('Table','Table'[ID]=EARLIER('Table'[ID])),'Table'[Sub Level],",")
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
@kampyy , A new column
concatenatex(Filter(Table, [ID] = earlier([ID]) ) , [Sub Level] )
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
Hello,
Is it possible to make your formula dynamic in a measure?
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |