Forum Discussion

maashi's avatar
maashi
Frequent Visitor
2 years ago
Solved

Vlookup, multiple filters

I have been trying to replicate something I had been doing very manually on Excel, involving a VLOOKUP then counting non blanks in the result. I have attached the sample data for that purpose, and th...
'Need help'
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi maashi ,

    I can not see the sales order type in the sample data.

    Based on the description, try to use the following dax formula.

    Working Column =
VAR _order = 'Table2_2'[Original Sales Order]
RETURN
    MAXX(
        FILTER(
            'Table2_2',
            'Table2_2'[Sales Order No] = _order &&
            'Table2_2'[Sales Order Type] IN {"Type1", "Type2"}
        ),
        'Table2_2'[Sales Order No]
    )

     

    Best Regards,

    Wisdom Wu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi maashi ,

I can not see the sales order type in the sample data.

Based on the description, try to use the following dax formula.

Working Column =
VAR _order = 'Table2_2'[Original Sales Order]
RETURN
    MAXX(
        FILTER(
            'Table2_2',
            'Table2_2'[Sales Order No] = _order &&
            'Table2_2'[Sales Order Type] IN {"Type1", "Type2"}
        ),
        'Table2_2'[Sales Order No]
    )

 

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

maashi's avatar
maashi
Frequent Visitor
2 years ago
Thank you so much, that worked seamlessly. Much appreciated. Marcy