Forum Discussion
Solved
Help
If somebody can help me
Example: i have the column
Screening
Research example1
Research example2,
Excluded example1
Excluded example2,
All in the same column and i need to show the count just with the first part
Example:
screening | count
Reaserch 4
Excluded 5
I don´t know how to do it
sorry por the lack of details my writing in english is not the best
See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkotTk0sSs5QSK1IzC3ISTVUitXBFDXSAQu7ViTnlKakpqAqRheFKibJZNo5g0aKYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Sacreening = _t]), #"Extracted Text Before Delimiter" = Table.TransformColumns(Source, {{"Sacreening", each Text.BeforeDelimiter(_, " "), type text}}), #"Grouped Rows" = Table.Group(#"Extracted Text Before Delimiter", {"Sacreening"}, {{"Count", each Table.RowCount(_), Int64.Type}}) in #"Grouped Rows"
1 Reply
Replies have been turned off for this discussion
See the working here - Open a blank query - Home - Advanced Editor - Remove everything from there and paste the below code to test
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCkotTk0sSs5QSK1IzC3ISTVUitXBFDXSAQu7ViTnlKakpqAqRheFKibJZNo5g0aKYwE=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Sacreening = _t]), #"Extracted Text Before Delimiter" = Table.TransformColumns(Source, {{"Sacreening", each Text.BeforeDelimiter(_, " "), type text}}), #"Grouped Rows" = Table.Group(#"Extracted Text Before Delimiter", {"Sacreening"}, {{"Count", each Table.RowCount(_), Int64.Type}}) in #"Grouped Rows"