Forum Discussion

gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
9 years ago
Solved

Lookupvalue equivalent to search for text values

Hi DAXers, I am wondering is there a way to search for a text string in DAX and return a value like with LOOKUPVALUE? I believe I can not use LOOKUPVALUE because ir requires a scalar search value. L...
Need Help
  • MFelix's avatar
    MFelix
    9 years ago
    Hi gvg,

    Assuming you want to return the full data LOOKUPVALUE works fine with text if you only want part of tge value you need to use SEARCH.

    Regards,
    MFelix
  • MFelix's avatar
    MFelix
    9 years ago
    Hi gvg,

    You are making a measure right? In dax you can use max and.min also with text fields, so if.ypu use the.last sintax should work.
MFelix's avatar
MFelix
Icon for Super User rankSuper User
9 years ago

Hi @gvg,

 

This sould work even as part of another measure depending on the way you set up your measure.

 

Can you please elaborate how you are doing that?

 

Regards,

MFelix

gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
9 years ago

Won't be able to reproduce it. I was experimenting with lots of solutions.