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: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
HeatherBisher
Frequent Visitor

Comparing 2 tables of data to see who is available.

‎05-01-2024 08:27 AM

Hello!

I am trying to create a visual that will compare a Table " Manage Staff" to a Table " All Staff" 

Manage Staff Tells me who is assigned to what job each week, All Staff is the name of all the staff. 

I have the following filters on the page, Date, Shift, Site 

Both Tables contain the employee ID,  Name, & Shift. 

So I need to see who is NOT assigned or is available for assignment. 

All Staff 

HeatherBisher_0-1714576924245.png

Manage Staff 

HeatherBisher_1-1714577241002.png

 

Message 1 of 9
241 Views
0
8 REPLIES 8
HeatherBisher
Frequent Visitor

Friday

That works but the Moment I add a Date Slicer it no longer works

 

Message 6 of 9
133 Views
0
vanessafvg
Super User
Super User
In response to HeatherBisher

Friday

please give more information about what you are trrying  to do with the date?  the quality of the solution given depends on the amount of detail provided.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Message 7 of 9
128 Views
0
HeatherBisher
Frequent Visitor
In response to vanessafvg

Monday

The Data changes based on the Dates. I build the Schedules and need to see who is still availible or Not assigned in a class for a specific date. When I add the date Slicers in all the Visuals go blank. 

For the week of 5/2, I should have a different list of avalible personel then on 4/28.

Message 8 of 9
33 Views
0
vanessafvg
Super User
Super User
In response to HeatherBisher

Monday

please provide more information, i cannot see what you are doing from your explanation, otherwise its down to guess work. I have no idea what you have implemented.

 

1. provide screenshots, provide a screehshot of your current model and the relationships. give an example of your expected result

2. provide screenshots of what its currently doing that you do not want it to do.

3. provide an example to test with so that one can properly test the solution.

 

 

 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Message 9 of 9
21 Views
0
HeatherBisher
Frequent Visitor

‎05-01-2024 12:20 PM

@vanessafvg  Here are the 2 tables I am trying to compare 

Sorry I could not get the file to up load.

All Staff

 

staff IDFirst namelastnameTitleDivisioninclass roleteamShift
100881ASHLEYJOHNSONCOORDINATOR, TRAINING C, L,T, F, NSHELLI ROBERTS1
026871MARQUITAMCCLENDONCOORDINATOR, TRAINING C, L,T, F, NSHELLI ROBERTS1
996309SHERRYORTECOORDINATOR, TRAINING C, L,T, F, NSHELLI ROBERTS1
105439ALEXANDERTODDCOORDINATOR, TRAINING C, L,T, F, NSHELLI ROBERTS2
007993ASHLEYDONATHSR TRAINER L,T, F, NALEXANDER TODD2
102666CRYSTALGRAHAMSR TRAINER L,T, F, NALEXANDER TODD2
868580JENNIFERLEESR TRAINER L,T, F, NALEXANDER TODD2
022823ALEXISMARTINSR TRAINER L,T, F, NALEXANDER TODD2
035113HEATHERRACHSR TRAINER L,T, F, NALEXANDER TODD2
103935DAVIDWITHEMSR TRAINER L,T, F, NALEXANDER TODD2
030161PATRICIALOVELANDSR TRAINER L,T, F, NALEXANDER TODD2
027464JENNIFERCLAYSR TRAINER L,T, F, NASHLEY JOHNSON1
102254JENNIFERGILLMANNSR TRAINER L,T, F, NASHLEY JOHNSON1
102914MARYLARSONSR TRAINER L,T, F, NASHLEY JOHNSON1
110161JENNIFERPRUITTSR TRAINER L,T, F, NASHLEY JOHNSON1
026056AMANDAWORRELLSR TRAINER L,T, F, NASHLEY JOHNSON1
032714KRISTINBOZEMANSR TRAINER L,T, F, NMARQUITA MCCLENDON1
023178NANCYDAVILASR TRAINER L,T, F, NMARQUITA MCCLENDON1
021483MELINDAMASCAGNISR TRAINER L,T, F, NMARQUITA MCCLENDON1
032721JASMILLMILLERSR TRAINER L,T, F, NMARQUITA MCCLENDON1
031460CHERYLOAKSSR TRAINER L,T, F, NMARQUITA MCCLENDON1
026779BRANDONDAWSONSR TRAINER L,T, F, NSHERRY ORTE1
025934MICHELLEMCCOLLEYSR TRAINER L,T, F, NSHERRY ORTE1
036331AMBERSTOTLERSR TRAINER L,T, F, NSHERRY ORTE1

 

Manage Staff

TP IDTP DateTP WEEKClass StartSession IDClass nameSteStaff IDFirst nameLast nameStaff DateRole
3421/29/2024Enhancement & MS Training Week of 1/29/20241/29/2024105-24CS 200ICO023178NANCYDAVILA2/5/2024Lead Trainer
3462/5/2024Trainer RNS Week of 2/5/20242/5/2024RNS020524TN 206813007993ASHLEYDONATH2/9/2024Trainer RNS
3462/5/2024Trainer RNS Week of 2/5/20242/5/2024RNS020524TN 206813026056AMANDAWORRELL2/7/2024Trainer RNS
3462/5/2024Trainer RNS Week of 2/5/20242/5/2024RNS020524TN 206813029104VENEKING2/5/2024Trainer RNS
3462/5/2024Trainer RNS Week of 2/5/20242/5/2024RNS020524TN 206813032714KRISTINBOZEMAN2/7/2024Trainer RNS
3462/5/2024Trainer RNS Week of 2/5/20242/5/2024RNS020524TN 206813034653ELAINESEARCY2/5/2024Trainer RNS
3462/5/2024Trainer RNS Week of 2/5/20242/5/2024RNS020524TN 206813102914MARYLARSON2/7/2024Trainer RNS
3482/5/2024Enhancement & MS Training Week of 2/5/20242/5/2024107-24OT 200PIN013878KATHRYNMILLER2/14/2024Coach
Message 5 of 9
195 Views
0
vanessafvg
Super User
Super User

‎05-01-2024 10:53 AM

can you provide some sample data?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Message 2 of 9
204 Views
0
HeatherBisher
Frequent Visitor
In response to vanessafvg

‎05-06-2024 06:15 AM

please see above @vanessafvg 

Message 3 of 9
161 Views
0
vanessafvg
Super User
Super User
In response to HeatherBisher

Thursday

There several ways to achieve this  and this a very simple example

relate the two tables to each other by staff id and the create a measure (i created a count rows of the staff management table)

 

putting both staff id's on from bot tables on the same visual ie second visual at the bottom, and then be sure to show items with no data by selected it by clicking on the staff id from all staff, right click on the measure  where you place it in the visual (highlighted in pink).  with a bit of conditional formatting you can see who is not assigned to work from the all staff table.  there were a few examples that weren't in all staff but only in the second table.    there are other ways to achieve this just depends on how you want to display it.

 

vanessafvg_1-1715286369987.png

see model attached and let me know if you have any questions.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Staff Management.pbix
Message 4 of 9
143 Views
0

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All