Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello guys,
I am trying to add custom column in power query editor to show how many times the id appears as shown below in excel . I am only seeing DAX but not that much in power query.
Thank you
Solved! Go to Solution.
Hi @Ady23
The process to achieve this with Power Query is as follows:
1. Group By on the ID column (using that as the key)
2. Change the aggregation to "All Rows" and the new column name to "temp" and click Okay
That will generate code that looks something like this:
Table.Group( YourTable, {"ID"}, {{"temp", each _, type table[...]}})
update this part: each _
into this: each Table.AddIndexColumn( _, "# of occurance", 1, 1)
Your choice remove the type table [...] OR include the new field type table [... , #"# of occurance"=number]
I hope this is helpful
Hi @Ady23
The process to achieve this with Power Query is as follows:
1. Group By on the ID column (using that as the key)
2. Change the aggregation to "All Rows" and the new column name to "temp" and click Okay
That will generate code that looks something like this:
Table.Group( YourTable, {"ID"}, {{"temp", each _, type table[...]}})
update this part: each _
into this: each Table.AddIndexColumn( _, "# of occurance", 1, 1)
Your choice remove the type table [...] OR include the new field type table [... , #"# of occurance"=number]
I hope this is helpful
Check out the July 2025 Power BI update to learn about new features.