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)...?