Forum Discussion

Gregory-N's avatar
Gregory-N
Regular Visitor
4 years ago
Solved

DAX Max value if two columns content match

Hi,    I need help to get the MAX from a column if two other columns data is a match.   See example and screenshots below;   If [ShipmentNo] in my Logistics table is = to [strCntDocID] in my Co...
Need Help
  • Fowmy's avatar
    Fowmy
    4 years ago

    Gregory-N 

    Add a Calculated Column in your Logistics table as follows:

    SeqNoMax =
MAXX (
    FILTER ( ContainerDTtable, ContainerDTtable = LogisticTable[ShipmentNo] ),
    ContainerDTtable[IntSeqNo]
)
Gregory-N's avatar
Gregory-N
Regular Visitor
4 years ago

Good morning Fowmy 

 

Thanks for the response.

 

Unfortunately this doesn't work, it brings up an #ERROR.

 

The error message is "The expression refers to multiple columns. Multiple columns cannot be converted to a scalar value"

 

I added the column as per your above measure:

 

SeqNoMax 

= MAXX (
    FILTER ( tblContainersDT, tblContainersDT = 'PD&P Logistics'[ShipmentNo] ),
    tblContainersDT[IntSeqNo]
)
 
Please help with making this work.
 
Regards;
Greg