Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Team, I hope you can help me with these.
I have this dataset.
ID | Concept | alpha_value | number_value | date_value |
Annabel | Gender | Female | ||
Annabel | Country | France | ||
Annabel | City | Nantes | ||
Annabel | Weight | 78.8 | ||
Annabel | Height | 1.78 | ||
Annabel | Birth Date | 1/12/1983 | ||
Bruce | Gender | Male | ||
Charlotte | Gender | Female | ||
Charlotte | Country | Italy | ||
Charlotte | City | Pisa | ||
Charlotte | Weight | 76.5 | ||
Charlotte | Height | 1.75 | ||
Charlotte | Siblings | 4 | ||
Charlotte | Pets | 2 | ||
Charlotte | Birth Date | 4/22/1943 | ||
Charlotte | First Job Date | 2/19/1958 | ||
Charlotte | Last Job Date | 3/24/2023 |
I'd like to pivot Concept column, using alpha_value, number_value and date_value as values, keeping data type and getting this table as a result, using DAX to keep data conectivity mode as direct
ID | Gender | Country | City | Weight | Height | Siblings | Pets | Birth Date | First Job Date | Last Jobe Date |
Annabel | Female | France | Nantes | 78.8 | 1.78 | 1/12/1983 | ||||
Charlotte | Female | Italy | Pisa | 76.5 | 1.75 | 4 | 2 | 4/22/1943 | 2/19/1958 | 3/24/2023 |
I'm getting data from a DB and I'd like to keep direct mode.
Thanks and Regards!
Solved! Go to Solution.
@carvajalaa see attached pbix file, it will get you started.
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.
Thankyou parry2k, good start, your code in power query help me a lot to refine mine, it was a little rustic, in the end, I have to change to import mode because of the power query commands, I'll keep trying to get some code for DAX if it exists, or a SQL code to import data from database already ordered as needed, I appreciate your help. Regards!
@carvajalaa @Please accept it as a solution so that others can benefit from it.
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.
@carvajalaa see attached pbix file, it will get you started.
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.
@carvajalaa what is the condition? X in any row of the ID column?
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.
Thankyou parry2k, good start, your code in power query help me a lot to refine mine, it was a little rustic, in the end, I have to change to import mode because of the power query commands, I'll keep trying to get some code for DAX if it exists, or a SQL code to import data from database already ordered as needed, I appreciate your help. Regards!
Hi parry2k, thanks for answer, I rephrased the question and changed data to make it more understandable, with this new data, I'm trying to pivot Concept column, using all person records that are Female in the alpha_value column, I mean to use all records of Annabel and Charlotte, using alpha_value, number_value and date_value as values, keeping data type and get a table as shown above. Thanks again and regards!
User | Count |
---|---|
86 | |
83 | |
67 | |
61 | |
57 |
User | Count |
---|---|
138 | |
112 | |
94 | |
84 | |
70 |