Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
This is not an urgent concern but I am just curious how to do this without actually converting the list to table.
let StartDate= DateTime.Date(DateTime.LocalNow()), EndDate= Date.AddYears(StartDate,-2), #"List of Lists" = List.Zip({ List.Generate( ()=>EndDate, each _ <= StartDate, each Date.AddDays(_,1)), List.Generate( ()=>StartDate, each _ >= EndDate, each Date.AddDays(_,-1))}), #"Converted to Table" = Table.FromList(#"List of Lists", Splitter.SplitByNothing(), null, null, ExtraValues.Error), #"Extracted Values" = Table.TransformColumns(#"Converted to Table", {"Column1", each Text.Combine(List.Transform(_, Text.From), ","), type text}), Column1 = #"Extracted Values"[Column1] in Column1
In the script above, I would like to insert a step after #"List of Lists" that will combine the list of lists for each row into just one list. I've tried List.Transform but I couldn't get it right.
Proud to be a Super User!
Solved! Go to Solution.
You may refer to the code below.
Column1 = List.Transform(#"List of Lists" , each Text.Combine(List.Transform(_, each Text.From(_)), ","))
You may refer to the code below.
Column1 = List.Transform(#"List of Lists" , each Text.Combine(List.Transform(_, each Text.From(_)), ","))
User | Count |
---|---|
85 | |
84 | |
67 | |
61 | |
56 |
User | Count |
---|---|
137 | |
110 | |
92 | |
84 | |
69 |