Forum Discussion

Mashoh95's avatar
Mashoh95
Regular Visitor
7 years ago

Deduplication based on two column

Hi, Im very very very new to Power Bi, Just wondering whether Power Bi have this kind of capabilities, Imagine i got set of data with 3 column as below:   Column 1 (Email address) ha...
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
7 years ago

Hi Mashoh95,

 

I am not very clear about your requirement. What do you mean "Column 1 is connected with column 2"? And you said "dedup the duplicate data of column 1 based on column 3", what is the rule? Please provide some sample data and show us your desired output.

How to Get Your Question Answered Quickly

 

Best regards,

Yuliana Gu

Mashoh95's avatar
Mashoh95
Regular Visitor
7 years ago

Hi Yuliana,

Thanks for the reply,

What i wanted to know whether PowerBI have this kind of capabilities,

For example:




As u can see in situation A, column 1 got same email (a@a) as column 3.
After dedup, it will becomes as situation B .
As i mention before, this can be done using excel but if the record very large. Excel will break.
Just wondering whether PowerBI can do this kind of deduplication.