Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more

Reply
moonligh
New Member

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 

 

 

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

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

1 REPLY 1
Vijay_A_Verma
Super User
Super User

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"

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors