Lookup Distinct Admin Names to a Blank table

[Newbie22]

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

[mangaus1111 · Accepted solution]

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.

[Analystmate]

@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

[onurbmiguel_ · Accepted solution]

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 · Accepted solution]

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]

Thank you so much for making my work easier 😭