Forum Discussion
Create a new table from existing table with multiple filters
Hello, I'm trying to create a new table from an existing table, but on two columns I would like a filter applied:
Column OTIF="Y" and column DG or Config =notblank
I am now using the following formula, but that only includes 1 filter: SELECTCOLUMNS(FILTER('OTIF','OTIF'[Ship set flag]="Y"),"Ship set flag",OTIF[Ship set flag],"Ship set ID",OTIF[Ship set ID],"Order number",OTIF[Order Number],"DG or Config",OTIF[DG or Config])
Thanks for your help!
Anonymous
You can apply multiple filters like this.
Table = SELECTCOLUMNS ( FILTER ( 'OTIF', 'OTIF'[Ship set flag] = "Y" && NOT ISBLANK ( 'OTIF'[Config] ) ), "Ship set flag", OTIF[Ship set flag], "Ship set ID", OTIF[Ship set ID], "Order number", OTIF[Order Number], "DG or Config", OTIF[DG or Config] )
3 Replies
- jdbuchanan71
Super User
Anonymous
You can apply multiple filters like this.
Table = SELECTCOLUMNS ( FILTER ( 'OTIF', 'OTIF'[Ship set flag] = "Y" && NOT ISBLANK ( 'OTIF'[Config] ) ), "Ship set flag", OTIF[Ship set flag], "Ship set ID", OTIF[Ship set ID], "Order number", OTIF[Order Number], "DG or Config", OTIF[DG or Config] ) I have an almost similar thing, but now instead of a second filter with ISBLANK I need to add 2 filters on the same column, so in total I have 3 filters, is that possible?
FILTER(OTIF,OTIF[Ship set flag]="Y"
FILTER(OTIF,OTIF[Line status]="Awaiting_Supply"
FILTER(OTIF,OTIF[Line status]="Supply_Partial"
Total formula I have now but wasn't working:
Shipset Y&Line status = SELECTCOLUMNS(FILTER(OTIF,OTIF[Ship set flag]="Y") && FILTER(OTIF,OTIF[Line status]="Awaiting_Supply",
"Ship set flag",OTIF[Ship set flag],"Ship set ID",OTIF[Ship set ID],"Order line status",OTIF[Line status],"Order number",OTIF[Order Number]))- jdbuchanan71
Anonymous
That one you can do using IN.
Shipset Y&Line status = SELECTCOLUMNS ( FILTER ( 'OTIF', 'OTIF'[Ship set flag] = "Y" && OTIF[Line status] IN {"Awaiting_Supply", "Supply_Partial"} ), "Ship set flag", OTIF[Ship set flag], "Ship set ID", OTIF[Ship set ID], "Order number", OTIF[Order Number], "DG or Config", OTIF[DG or Config] )