Add information in extra columns same row

[romovaro]

Hello Pbix community

I have a question regarding the table below:

I have Principal Project number in the CUID column and the integration project number is the same as the CUID column but with

an extra "i".

Name	CID	CUID	Country	Project Scope	Actual/Schedule Go Live	Project Manager / Coordinator
Customer A	AAA	NCPFFR01	France	Standard	2020-01-01	Dorottya Szabo
Customer A	AAA	NCPFFR01i	France	Integration WW	2021-01-01	Mary Mayers
Customer A	AAA	NCPFFR02	France	Standard	2021-01-01	John Smith
Customer A	AAA	NCPFFR03	France	Standard	2021-01-01	Akira Wars
Customer B	ASPN	ASPNMY01	Malaysia	Standard	2021-01-01	Gerard Monte
Customer B	ASPN	ASPNMY01i	Malaysia	Integration WW		Sandra Verdi
Customer B	ASPN	ASPNES01	Spain	Standard	2021-01-01	Mary Mayers
Customer B	ASPN	ASPNCN01	China	Standard	2020-07-31	John Smith
Customer B	ASPN	ASPNCN01i	China	Integration WF	2020-07-01	Akira Wars

I have created diff formulas to show "if integration or not", etc.. but I have been asked to create a new visual showing all the information but using ONLY one row.

THe idea would be to show only the Principal Project number and "If integration included" then show all the columns in different columns but same row. (excel image below)

Any tip welcome

thanks.

df

[Greg_Deckler · Accepted solution]

@romovaro Probably need a disconnected table for your columns and a single measure that, based on the column returns the corresponding information. 

[romovaro]

Hi @Greg_Deckler 

As discussed I created an extra table using the "summarize" function with the columns I wanted to "duplicate" to add in the main table

In the extra table I created a column (called CUID-1) that allows me to get the info I need and I used "Lookupvalue" function to get the results:

CUID Integration = LOOKUPVALUE(Tabla[CUID],Tabla[CUID-1],'PV Cel File'[CUID],"")

CUID with Scope = LOOKUPVALUE(Tabla[Project Scope],Tabla[CUID-1],'PV Cel File'[CUID],"")

 What I realize is that is not working all the time. 

From the image above, i have Australia and Austria. It seems with Australia I get all the info in my columns highligthed in blue but for Austria (same Information, Same Fields, etc...) is blank. For "Status Integration" it seems all fields are working ok. Any idea?

THanks

[romovaro]

hi @Greg_Deckler 

I decided to use powerquery...duplicate table + merge.

Worls fine.

Thanks