Reply
Syndicate_Admin
Administrator
Administrator
Syndicated - Inbound

Add an Incremental Repeated Value Count column

Source Community: Power BI Spanish | Source Author Name: JaviBI

Hello, in power query I have a column with ordered order numbers but that can be repeated for example with this data (222,333,333,333,555,555) and I want to add a column where I incrementally count the number of each order, that is, the result would be this from the Counting column, how do you do this in power Query by adding a calculated column?

ORDER IDCount
2221
3331
3332
3333
5551
5552
2 REPLIES 2
parry2k
Super User
Super User

Syndicated - Outbound

@Syndicate_Admin start a new blank query click advanced editor and copy the following M code, it has all the steps to make this happen.

 

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjIyUorViVYyNjbGSpuamiLoWAA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}),
    #"Grouped Rows" = Table.Group(#"Changed Type", {"Column1"}, {{"all", each Table.AddIndexColumn(_, "Index",1,1)}}),
    #"Expanded all" = Table.ExpandTableColumn(#"Grouped Rows", "all", {"Index"}, {"Index"})
in
    #"Expanded all"

 

parry2k_0-1700789306932.png

 



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

GiaPa
Frequent Visitor

Syndicated - Outbound

What if our original column is text and we want to count the number of time the text appears? Do we just change the int64 type?

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)