Forum Discussion

Helper I

6 years ago

create a new table from an existing table

All Extremely new to power bi. I am looking to create a new table from an existing table. But I want to exclude any lines with the values "in Production", "Shipped" and "Delivered" in the ord...

Need Help

amitchandak

Super User

6 years ago

tjeffries

filter(Table, not(table[Order Status] in {"In Production","Shipped","Delivered"}))

calculatetable(Table,filter(Table, not(table[Order Status] in {"In Production","Shipped","Delivered"})))

Forum Discussion

create a new table from an existing table

Related content

Lakehouse Table Generate Create Table

Create new table

Cannot create liquid clustering on existing unpartitioned table

Create a new table from columns from existing tables

Create rows from 2 tables