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.
Hello everyone,
I have a column with four groups and I wanted to create another column to have a count indicator in each group of this column.
How can I do that?
My dataset
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vRTMDayVNJRUorVIZFnYmQA5zkpGBmbEMkzNjCgKQ/VZZTzYgE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Group = _t, #"Cont by Group" = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Group", type text}, {"Cont by Group", type text}})
in
#"Changed Type"
Solved! Go to Solution.
Hi @Anonymous
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vRTMDayVIrVIY5pYmQAYTopGBmb4GcaGxhQi4lkMRnMWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Group = _t]),
#"Grouped Rows" = Table.Group(Source, {"Group"}, {{"Cont by Group", each List.Numbers(1,Table.RowCount(_))}}),
#"Expanded Cont by Group" = Table.ExpandListColumn(#"Grouped Rows", "Cont by Group")
in
#"Expanded Cont by Group"
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Hi,
Refer to the solution offered by ImkeF here - Solved: Custom column Index or Ranking by other column - Microsoft Power BI Community.
Hope this helps.
Hi @Anonymous
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45W8vRTMDayVIrVIY5pYmQAYTopGBmb4GcaGxhQi4lkMRnMWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Group = _t]),
#"Grouped Rows" = Table.Group(Source, {"Group"}, {{"Cont by Group", each List.Numbers(1,Table.RowCount(_))}}),
#"Expanded Cont by Group" = Table.ExpandListColumn(#"Grouped Rows", "Cont by Group")
in
#"Expanded Cont by Group"
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
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.
User | Count |
---|---|
114 | |
100 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |