Forum Discussion

Sabsy's avatar
Sabsy
Frequent Visitor
7 years ago
Solved

LOOKUPVALUE with multiple results

Hi all,   I am new to Power BI so appologies if this is a silly question but I've been stuck on finding a solution and could really use some guidance.    I have two tables that do not contain a u...
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

     

    Hope this helps.  You may download my PBI file from here.

     

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

Hi,

 

Will Table2 have unique ID's?

  • Sabsy's avatar
    Sabsy
    Frequent Visitor
    7 years ago
    It doesn’t at the moment but I could create a unique ID.
    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      7 years ago

      Hi,

       

      Will it be OK, if i can write a measure to get all reults for a particular ID in one cell (seperated by commas)?

      • Sabsy's avatar
        Sabsy
        Frequent Visitor
        7 years ago
        Yes, that can work as I can split them out manually after.