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,

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.
gvg's avatar
gvg
Icon for Post Prodigy rankPost Prodigy
9 years ago

OK, it works for a standalone measure. My problem was that I've been using it as part of another formula.

Thanks!

  • 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.