Forum Discussion

Chris1300's avatar
Chris1300
Icon for Helper II rankHelper II
3 years ago
Solved

Search for multiple keywords across table

I have 2 independent tables, not related in powerBI:   Keyword List apple bird red tree John bike   Sentence John has a red bike. The tree is green. The bird...
Need Help
  • CNENFRNL's avatar
    CNENFRNL
    3 years ago

    DAX is not created for addressing this although it's powerful enough to cover it.

     

    For fun only, a showcase of powerful Excel worksheet formula,

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

You may download my PBI file from here.

Hope this helps.

  • Chris1300's avatar
    Chris1300
    Icon for Helper II rankHelper II
    3 years ago

    Thanks for the solution in Power Query, but its really slow for my overall tables. Is this possible to do in DAX? I want to compare.