Forum Discussion
Add information in extra columns same row
romovaro Probably need a disconnected table for your columns and a single measure that, based on the column returns the corresponding information.
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],"")
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