Pivot Table with DAX

[carvajalaa]

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!

[parry2k · Accepted solution]

@carvajalaa see attached pbix file, it will get you started.

[parry2k]

@carvajalaa @Please accept it as a solution so that others can benefit from it.

[parry2k · Accepted solution]

@carvajalaa see attached pbix file, it will get you started.

[parry2k]

@carvajalaa what is the condition? X in any row of the ID column?

[carvajalaa · Accepted solution]

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]

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!