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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Cree una nueva tabla a partir de la tabla existente con varios filtros

Hola, estoy intentando crear una nueva tabla a partir de una tabla existente, pero en dos columnas me gustaría aplicar un filtro:

Columna OTIF "Y" y la columna DG o Config (No en blanco)

Ahora estoy usando la siguiente fórmula, pero eso sólo incluye 1 filtro: 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[DG o Config])

¡Gracias por tu ayuda!

1 ACCEPTED SOLUTION
jdbuchanan71
Super User
Super User

@MalouK93

Puede aplicar varios filtros como este.

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]
)

View solution in original post

1 REPLY 1
jdbuchanan71
Super User
Super User

@MalouK93

Puede aplicar varios filtros como este.

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]
)

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors