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,

 

To get TableB, please new a calculated table with below formula:

TableB =
SUMMARIZE (
    TableA,
    TableA[Name],
    "Future Bookins", SUM ( TableA[Future] ),
    "Past Bookings", SUM ( TableA[Past] )
)

Best regards,

Yuliana Gu

KateEC's avatar
KateEC
Frequent Visitor
8 years ago

Thanks for your help - I'm not quite sure which columns the formula you've written is referring to on my example? I don't think I understand it enough to pick it apart... :/

  • 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