Forum Discussion

abukapsoun's avatar
abukapsoun
Icon for Post Patron rankPost Patron
3 years ago
Solved

Returning a value based on a search range

Hi,   I am looking for your help finding out the DAX formula to create the following scenario. thank you   Name Country New Column     AA XX if AA has XX in country column, then retu...
Need Help
  • rajulshah's avatar
    rajulshah
    3 years ago

    abukapsoun ,

     

    Please see if the following DAX resolves your issue:

    Column =
CALCULATE ( MAX ( [Country] ), ALLEXCEPT ( Countries, Countries[Name] ) )