Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now

Reply
lastnn30
Post Patron
Post Patron

Create questions to analyze data in power BI - Attendance scenario

‎03-19-2022 07:15 PM

Hi

I have 2 tables. One has Name of all employees and their dept and the second one has a list of all people who attended a training.  

 

lastnn30_1-1647742312187.png

 

I want to know who attended the training and who is not. I can link them in data model (1 to 1) and then create a table visiual and put 1 column as employee names and second column is Addendance names. Can you please come with some questions for me to analyze these data so I can learn from these questions. Thank you very much.

 

Labels:
Message 1 of 5
973 Views
0
1 ACCEPTED SOLUTION
Thejeswar
Super User
Super User

‎03-19-2022 08:01 PM

Hi @lastnn30 ,

Is there someway you think you can achieve it without joining those table?

If so, explore what are they?

View solution in original post

Message 2 of 5
938 Views
4 REPLIES 4
lastnn30
Post Patron
Post Patron

‎03-19-2022 08:47 PM

Wow, I do not know how? I am new in PowerBI. I know using Vlookup in excel can do it but not power bi. Thank you very much.

Message 3 of 5
929 Views
0
Thejeswar
Super User
Super User
In response to lastnn30

‎03-19-2022 11:43 PM

Hi @lastnn30 ,

We also have lookup option in Power BI. Just google it and you will get enough examples for the same

 

Regards,

 

Message 4 of 5
910 Views
lastnn30
Post Patron
Post Patron
In response to Thejeswar

‎03-20-2022 06:18 AM

I did not know that. Thanks a lot for this hint. I am going to google it now. Thanks again.

Message 5 of 5
890 Views
0
Thejeswar
Super User
Super User

‎03-19-2022 08:01 PM

Hi @lastnn30 ,

Is there someway you think you can achieve it without joining those table?

If so, explore what are they?

Message 2 of 5
939 Views

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

February Power BI Update Carousel

Power BI Monthly Update - February 2026

Check out the February 2026 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All