Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Solved! Go to Solution.
Hi @muggydaniel
His this that you want?
take a look at power query in this file:
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!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
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
Hi @muggydaniel
His this that you want?
take a look at power query in this file:
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!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
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!
Best regards
Bruno Costa | Super User
Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!!
Take a look at the blog: PBI Portugal
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
125 | |
78 | |
76 | |
58 | |
51 |
User | Count |
---|---|
166 | |
84 | |
68 | |
67 | |
57 |