Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Lookup Value get the max value

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])
Need Help
  • TomasAndersson's avatar
    TomasAndersson
    3 years ago

    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?

2 Replies

  • TomasAndersson's avatar
    TomasAndersson
    Solution Sage
    3 years ago

    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?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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