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
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?
New Table under modeling and input formula:
TableC= CALCULATETABLE(TableA, TableA[Date] = MAY-1)
Thank you @hongjyan
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
TableC= SUMMARIZECOLUMNS(TableA[Title], FILTER(TableA, TableA[Date] = MAY-1))
it' did not work in Power Query Editor. The function SUMMARIZECOLUMNS was not recognized.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.