Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Dear all,
I'd kindly ask for your help, cause I really have no idea how to solve that.
I have two tables where I'd like to find all items for a specific date that are *not* in the table.
Personnel:
Projects:
I want to have a list with all people *not* working on a specific date.
So one option would be to have a resulting list like this:
or of course only the empty items (but this i can achive easy based on the last list):
Date | PNR |
02.01.2021 | 2 |
03.01.2021 | 2 |
03.01.2021 | 3 |
Any idea how to solve this and to get to the third combined list?
thanks in advance
regards
Sebastian
Solved! Go to Solution.
@SebastianAlmer ,I am assuming both tables are join
use this measure with first name , last name or any column with Personnel table
if(isblank(count(Project[project])),1,0)
Thanks @amitchandak
One more question: How would i do that to antoher table where i have an inactive relationship? how could I add USERLATIONSHIP there?
@SebastianAlmer , yes create a measure with userelationship and check for blank for the complete measure with userelationship
@SebastianAlmer ,I am assuming both tables are join
use this measure with first name , last name or any column with Personnel table
if(isblank(count(Project[project])),1,0)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |