Grouped Rows into Individual Rows

[muggydaniel]

Hi team 

Unsure how to explain. Showcasing example: 

Customer ID	Count of Applications	Area
1245	3	Bendigo
1267	4	Melbourne
1289	1	Gippsland

Each application would have 1x "main" application and the rest would be "child" applications

I would need to convert the above table where for the customer ID, each row is representative of 1x main app and the rest count of applications is child applications 

Customer ID	Application Type	Area
1245	Main	Bendigo
1245	Child	Bendigo
1245	Child	Bendigo
1267	Main	Bendigo
1267	Child	Bendigo
1267	Child	Bendigo
1267	Child	Bendigo
1289	Main	Gippsland

Does anyone know how this can be achieved? 

[muggydaniel]

Is it possible to complete that within the query itself to create individual rows instead of a measure inside? 

I am also appending the changes into another table that requires them to be single/individual rows

[onurbmiguel_ · Accepted solution]

Hi @muggydaniel 

His this that you want? 

take a look at power query in this file: 

counts.pbix

Best regards

Bruno Costa | Power Participant

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!

[onurbmiguel_]

hello @muggydaniel 

Please try this mesure: 

Measure = 
COUNTX('Table','Table'[Customer ID])

Best regards

Bruno Costa | Power Participant

Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍

You can also check out BI4ALL's website and our data solutions!