Forum Discussion
Power BI - Match and Return Columns between 2 tables
Hi,
I'm a new user to power BI and I am slowly learning the ropes!
Currently I have one table with data in Column A (Unique Entries) and Column B (non-unique) that have been formulated from a live source, however the sheet contains millions of rows and only about 1900 with Column A and B populated.
When I try to link a table, obviously the blanks are counting as non-unique so I am trying to make a seperate table with the 'Unique Column A' and coressponding 'Non- Unique Column B' entry.
On this seperate table, I've pulled the unique entries from column A with Table = DISTINCT(ALL(Table[ColumnA]))... Now all I want is the corresponding entry in Column B. It is not distinct, so thats out... If statment didn't work.
Can someone help me accomplish this task?
3 Replies
Hi,
I'm a new user to power BI and I am slowly learning the ropes!
Currently I have one table with data in Column A (Unique Entries) and Column B (non-unique) that have been formulated from a live source, however the sheet contains millions of rows and only about 1900 with Column A and B populated.
When I try to link a table, obviously the blanks are counting as non-unique so I am trying to make a seperate table with the 'Unique Column A' and coressponding 'Non- Unique Column B' entry.
On this seperate table, I've pulled the unique entries from column A with Table = DISTINCT(ALL(Table[ColumnA]))... Now all I want is the corresponding entry in Column B. It is not distinct, so thats out... If statment didn't work.
Can someone help me accomplish this task?
v-chuncz-msftCommunity Support
The requirement is not very clear. You may take a look at LOOKUPVALUE Function and FIRSTNONBLANK Function.
Let me see if I can't clarify
Column A Column B Column C XYZ A 1 ZYX B 2 JHGAS C 3 KJHAUW D 3 JQNNB E 4 OOIJW F 5 NWBNQ G 6 IYWGQ H 6 LKAJS OIYU LKJH OIQUWE POIUWQ OPIWQE OKJQW I need to have column B and C return themselves on a seperate table. I'm having difficulties because Column C is not unique...
Column A exists, but is irrelevant to the information I need to pull.