Forum Discussion

Newbie22's avatar
Newbie22
Icon for Resolver I rankResolver I
3 years ago
Solved

Lookup Distinct Admin Names to a Blank table

Hi Everyone,

 

How do I lookup to a blank table in PowerBI?

 

I have 3 tables below.

1. Blank Table

2. Case Table

3. Task Table

 

CASE Table

 

TASK Table

 

I want to get all Admin Names into one single column and put it in the "Blank table" but case number and task number are different. How would I do that?

 

This should how it looks like:

 

Admin Name

Michael John

Chris Kyle

Kelly Mae

Jessica Jones

Daniel Thomas

Need Help
Show and Tell
Tips and Tricks
  • mangaus1111's avatar
    mangaus1111
    3 years ago

    Hi Newbie22 ,

    try this

    Table = DISTINCT(
                 UNION(
                    SELECTCOLUMNS('Case',"Name",'Case'[Admin Name]),
                    SELECTCOLUMNS('Task',"Name",'Task'[Admin Name])
                 )
)

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • onurbmiguel_'s avatar
    onurbmiguel_
    3 years ago

    Hello 

    Try to crete this table : 

     

     

    Blank table = 
var _temp = 
    UNION(
        SUMMARIZE('Case','Case'[Admin Name]),
        SUMMARIZE(Task,Task[Admin Name])
    )

return 
DISTINCT(_temp)

     

    Best regards

    Bruno Costa | Continued Contributor

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal 

     

4 Replies

  • onurbmiguel_'s avatar
    onurbmiguel_
    Icon for Power Participant rankPower Participant
    3 years ago

    Hello 

    Try to crete this table : 

     

     

    Blank table = 
var _temp = 
    UNION(
        SUMMARIZE('Case','Case'[Admin Name]),
        SUMMARIZE(Task,Task[Admin Name])
    )

return 
DISTINCT(_temp)

     

    Best regards

    Bruno Costa | Continued Contributor

     

    Did I help you to answer your question? Accepted my post as a solution! Appreciate your Kudos!! 👍

    Take a look at the blog: PBI Portugal 

     

  • mangaus1111's avatar
    mangaus1111
    Icon for Solution Sage rankSolution Sage
    3 years ago

    Hi Newbie22 ,

    try this

    Table = DISTINCT(
                 UNION(
                    SELECTCOLUMNS('Case',"Name",'Case'[Admin Name]),
                    SELECTCOLUMNS('Task',"Name",'Task'[Admin Name])
                 )
)

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Newbie22's avatar
      Newbie22
      Icon for Resolver I rankResolver I
      3 years ago

      Thank you so much for making my work easier 😭

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

    Newbie22 Using power Query you can append  CASE Table and TASK Table data into a Blank table.

     

    If you do not need case number field then you can remove that and remove duplicate from admin name field