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]
)
Fowmy's avatar
Fowmy
Icon for Super User rankSuper User
4 years ago

Gregory-N 
Hope you added this as a calculated column in your logistic table?
Please share a screenshot of the error

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

Hi Fowmy ,

 

I did add it as a calculated column via fields, see below screenshot as requested.