Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have a table and some columns like the below:
I have a column with List value (item1) and I extract values with comma separate (item2) and the result is like the "pitch" column(item3).
Now I want to find Min and Max in the "pitch" column. Not each row total list. In this sample:
Max = 69.05
Min = -4.33
How can I do that?
Solved! Go to Solution.
Hi, @Bit2021
I make a sample. You can use create two columns to show your results.
Like this:
let
Source = {{1,2,3},{4,5,6},{7,8,9}},
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Text.Combine(List.Transform([Column1],(x)=>Text.From(x)),",")),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Max", each List.Max(List.Combine(#"Added Custom"[Column1]))),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Min", each List.Min(List.Combine(#"Added Custom"[Column1])))
in
#"Added Custom2"
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
Hi, @Bit2021
I make a sample. You can use create two columns to show your results.
Like this:
let
Source = {{1,2,3},{4,5,6},{7,8,9}},
#"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
#"Added Custom" = Table.AddColumn(#"Converted to Table", "Custom", each Text.Combine(List.Transform([Column1],(x)=>Text.From(x)),",")),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "Max", each List.Max(List.Combine(#"Added Custom"[Column1]))),
#"Added Custom2" = Table.AddColumn(#"Added Custom1", "Min", each List.Min(List.Combine(#"Added Custom"[Column1])))
in
#"Added Custom2"
Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.
Best Regards,
Community Support Team _ Janey
You can use List.Min and List.Max to get the result you need. As a sample, you can create a new column with this formula to get your min and max:
Text.Combine({List.Min([roll]), List.Max([roll])}, ";")
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |