Forum Discussion

hemingt's avatar
hemingt
Icon for Helper V rankHelper V
7 years ago

how to add column from another table based on filter condition

Hello,

 

I have several tables.

I want to create a new empty table, then add a new column from another table based on some filters, such as

Table A

Date  Title

May-1    Title-1

May-1 Title-2

May-1 Title-3

May-2 Title-4

 

I want to create a new table C, and add a new column from table A[title] which A[Date]=May-1.

How can I do?

Thank you!

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    New Table under modeling and input formula:

    TableC= CALCULATETABLE(TableA, TableA[Date] = MAY-1)

    • hemingt's avatar
      hemingt
      Icon for Helper V rankHelper V

      Thank you Anonymous 

       

      I just want to get one column, in my example is Title, to the new table.  and the condition may have several, in my example, is only one, TableA[Date]=May-1

      • Anonymous's avatar
        Anonymous
        Not applicable

        TableC= SUMMARIZECOLUMNS(TableA[Title], FILTER(TableA, TableA[Date] = MAY-1))