Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Newbie22
Resolver I
Resolver I

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

Newbie22_0-1667994553111.png

 

TASK Table

Newbie22_1-1667994590137.png

 

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

2 ACCEPTED SOLUTIONS
mangaus1111
Solution Sage
Solution Sage

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.

View solution in original post

onurbmiguel_
Super User
Super User

Hello 

Try to crete this table : 

 

onurbmiguel__0-1667995814125.png

 

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 

 

wp-1586527108426

 


Best regards


Bruno Costa | Super User


 


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 


 


View solution in original post

4 REPLIES 4
Analystmate
Helper II
Helper II

@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

Analystmate_0-1667995883307.png

 

 

 

onurbmiguel_
Super User
Super User

Hello 

Try to crete this table : 

 

onurbmiguel__0-1667995814125.png

 

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 

 

wp-1586527108426

 


Best regards


Bruno Costa | Super User


 


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
Solution Sage
Solution Sage

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.

Thank you so much for making my work easier 😭

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors