Lookup Value get the max value

[Invesco]

Hi Expert

How would you modify the following to get the max value for hco_Codes...

Measure

ProductName = LOOKUPVALUE(dev_shc_shingrix_activity[product_name],dev_shc_shingrix_activity[external_hco_code],dev_shc_shingrix_practice[parent_external_hco_code])

[TomasAndersson · Accepted solution]

Can you provide some more info? From what column do you want to find the max value? What are the cirumstances? How is your data structured?

[Invesco]

Hi Tomas = max value from the following two columns dev_shc_shingrix_activity[external_hco_code],dev_shc_shingrix_practice[parent_external_hco_code])