Forum Discussion

KateEC's avatar
KateEC
Frequent Visitor
8 years ago

Extracting Duplicate Distinct Data

Hi All,   I'm not very good at eplaining so i'll attach a picture.   I am trying to extract duplicate data from one table and get it into a distinct list in another table.   I have a table with...
Need Help
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi KateEC,

 

All column names being referred to in my formula are those in TableA you provided above. You just need to new a calculated table with my above DAX formula, then, you will get the output like TableB.

 

Regards,

Yuliana Gu

KateEC's avatar
KateEC
Frequent Visitor
8 years ago

Hi - thanks for that v-yulgu-msft - misread your column names there!

 

Sorry for another silly question - but how do I create a calculated table - i've read somewhere that this feature isn't available in Excel 2016 (which I'm using)...?

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    8 years ago

    Hi KateEC,

     

    The solution I posted above applied to Power BI desktop. If you want to analyze data in Excel tool, please post your question on Excel forum for more advice.

     

    Regards,

    Yuliana Gu