Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
I have a column which contains integer
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
Any idea how to do in Power BI ?
Thanks in advance
Go to Solution.
With Power Query, you can add a custom column like
View solution in original post
@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
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.