Forum Discussion

vjnvinod's avatar
vjnvinod
Impactful Individual
4 years ago
Solved

Dax help

Hi,   I have 2 tables GDS TNR data Portfolio FY22   I am using the below dax to get the name from TNR data,   Name modified = LOOKUPVALUE('Portfolio report FY22'[Engagement Partner],'Portfoli...
Need Help
Show and Tell
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi vjnvinod ,

     

    You can try like this:-

    Column =
CALCULATE (
    MAX ( 'Portfolio report FY22'[Engagement Partner] ),
    FILTER (
        'Portfolio report FY22',
        'Portfolio report FY22'[Engagement ID] = 'GDS TNR Data'[EngID]
            && 'GDS TNR Data'[EngID] = TRUE()
    )
)

    If its not worked then please share the sample data with expected output 🙂

     

    Thanks,

    Samarth 

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi vjnvinod ,

 

You can try like this:-

Column =
CALCULATE (
    MAX ( 'Portfolio report FY22'[Engagement Partner] ),
    FILTER (
        'Portfolio report FY22',
        'Portfolio report FY22'[Engagement ID] = 'GDS TNR Data'[EngID]
            && 'GDS TNR Data'[EngID] = TRUE()
    )
)

If its not worked then please share the sample data with expected output 🙂

 

Thanks,

Samarth