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
Icon for Microsoft Employee rankMicrosoft 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.