Solved: Help

moonligh · ‎06-20-2022

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

Vijay_A_Verma · ‎06-20-2022

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"

View solution in original post

Vijay_A_Verma · ‎06-20-2022

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"