cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
smpa01
Super User
Super User

Generating custom List

My datasource is following

 

 

 

let
    Source = {[r1=1,r2=2],[r1=3,r2=4],[r1=4,r2=5]}
in
    Source

 

 

 

 

How can I end up with a seperate custom list only for r1 or r2  from the above Source

e.g.

 

r1 = {1,3,4}

r2= {2,4,5}

 

I tried following and it did not work

 

Let

Source = as above,

r1= List.Generate(

()=> [i=0, j=Source{i}[r1]],

each [i] < List.Count(Source),

each [i=[i]+1, j=Source{i}[r1]],

each [j]

)

in r1

 

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






New Animated Dashboard: Sales Calendar


1 ACCEPTED SOLUTION
Vera_33
Super User
Super User

Hi @smpa01 

 

Maybe you can work from here, not very generic, just for your sample data

Vera_33_1-1634797912335.png

let
    Source = {[r1=1,r2=2],[r1=3,r2=4],[r1=4,r2=5]},
    Custom1 = [r1=List.Transform( Source, each Record.Field(_,"r1")),
r2= List.Transform( Source, each Record.Field(_,"r2"))]
in
    Custom1

View solution in original post

1 REPLY 1
Vera_33
Super User
Super User

Hi @smpa01 

 

Maybe you can work from here, not very generic, just for your sample data

Vera_33_1-1634797912335.png

let
    Source = {[r1=1,r2=2],[r1=3,r2=4],[r1=4,r2=5]},
    Custom1 = [r1=List.Transform( Source, each Record.Field(_,"r1")),
r2= List.Transform( Source, each Record.Field(_,"r2"))]
in
    Custom1

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors