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 have a column which contains integer
Level |
4 |
7 |
5 |
1 |
3 |
I have to generate sequence starting from 1 and upto the number in Level column in each row, sequence is seperated by comma.
expected output is
Level | sequence |
4 | 1,2,3,4 |
7 | 1,2,3,4,5,6,7 |
5 | 1,2,3,4,5 |
1 | 1 |
3 | 1,2,3 |
Any idea how to do in Power BI ?
Thanks in advance
Solved! Go to Solution.
With Power Query, you can add a custom column like
Text.Combine(
List.Transform({1..[Level]},each Text.From(_)),",")
With Power Query, you can add a custom column like
Text.Combine(
List.Transform({1..[Level]},each Text.From(_)),",")
@Hari01 Well, in DAX you could use a calculated column like:
sequence = CONCATENATEX(GENERATESERIES(1,[Level]),[Value],",")
I believe the equivalent in Power Query is List.Generate
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.