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 want to extract list of employees who dont fill out the response form.
Available data:
1. I have list of total employees.
2. Response from employees who fill on daily basis.
Issue:
Some employees dont fill out response form daily. So, employees who dont fill the form need to be listed in power BI.
Who makes entries via form can be easily extracted, but who dont make entries on response on daily basis couldnt be extracted.
Please help to achieve it
Hi @Anonymous
First, make sure you have relationships between tables
Second, add a measure into Employee table
Measure =
var _maxDays = CALCULATE(DISTINCTCOUNT(ResponseTable[Date]), ALL(ResponseTable))
RETURN
IF(DISTINCTCOUNT(ResponseTable[Date]) < _maxDays, FALSE(), TRUE())
Third, filter by FALSE() value of new Measure - it will match your demand
Hi @Anonymous ,
If you have the list of ALL Employees in one table.
And responses from form comes in the form a a different table..
You can use the merge option in Power Query to find the list of employees who have not responded.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hii... Thanks!! I tried this, but its showing whole people who doesnt fill.
I am looking for who didnt fill response by each day... I have time stamp in response sheet. Any solution pls?
TIA
Hi @Anonymous ,
Can you pls share sample data and how does your data model look like.
Regards,
Harsh Nathani
@harshnathani @az38 @amitchandak Please support
Hi...
Below are table 1 Rsponse table and table 2 is employee database. I want to pull out name of employees who didnt fill the response sheet daily.
So, I need daywise employee name who filed to fill.
If I filter for 22nd in merged sheet, I want Name "P" in non filled and M on 21st.
@Anonymous , you can add +0 to the measure and get all the employees
Total Customer = Count(Table[emp])+0
Or you can use this option
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 |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |