Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
hemingt
Helper V
Helper V

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 4
Anonymous
Not applicable

New Table under modeling and input formula:

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

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
Not applicable

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

Hello @Anonymous 

thank you.

it' did not work in Power Query Editor. The function SUMMARIZECOLUMNS was not recognized.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.