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... :/