Forum Discussion
Find the name with no entry
Hello, I need a help in getting the name who has not made the entry , below given is the example
I have few tables
Table 1 - It contains all the weeks
| Week |
| 01/01/2024 - 01/07/2024 |
| 01/08/2024 - 01/15/2024 |
| 01/16/2024 - 01/22/2024 |
| 01/23/2024 - 01/31/2024 |
Table2-It contains all the name and email
| Name | |
| A | [email protected] |
| B | [email protected] |
| C | [email protected] |
| D | [email protected] |
Table3 - It contains the name and the entries entered in weeks
| Week | name | total | |
| 01/01/2024 - 01/07/2024 | A | [email protected] | 31 |
| 01/01/2024 - 01/07/2024 | B | [email protected] | 34 |
| 01/01/2024 - 01/07/2024 | C | [email protected] | 67 |
| 01/08/2024 - 01/15/2024 | A | [email protected] | 43 |
| 01/08/2024 - 01/15/2024 | B | [email protected] | 23 |
| 01/08/2024 - 01/15/2024 | C | [email protected] | 12 |
| 01/08/2024 - 01/15/2024 | D | [email protected] | 98 |
| 01/16/2024 - 01/22/2024 | A | [email protected] | 12 |
| 01/16/2024 - 01/22/2024 | B | [email protected] | 54 |
| 01/16/2024 - 01/22/2024 | D | [email protected] | 45 |
I want to have a table with the name who has not marked hours as per the week , for example
D has not marked the hour for 01/01/2024 - 01/07/2024,01/23/2024 - 01/31/2024 week , similarly for other names as well
| Week | name | |
| 01/01/2024 - 01/07/2024 | D | [email protected] |
| 01/16/2024 - 01/22/2024 | C | [email protected] |
| 01/23/2024 - 01/31/2024 | A | [email protected] |
| 01/23/2024 - 01/31/2024 | B | [email protected] |
| 01/23/2024 - 01/31/2024 | C | [email protected] |
| 01/23/2024 - 01/31/2024 | D | [email protected] |
Hi Anonymous ,
Please see PBIX file attach.
3 Replies
- MFelix
Super User
Hi Anonymous ,
You can create the following measure:
Validation = IF(SELECTEDVALUE(Names[email]) in VALUES('Fact'[email]), BLANK(),1)Now you have two options:
- Add this value to you table and the result will be a table like this
You can decrease the size of the column or format the text to be white or a icon.
- Add the measure has a filter
- Select is not blank
- Right click the fields and Show items with no data
- MFelix
Hi Anonymous ,
Please see PBIX file attach.