I want to extract list of employees who dont fill out the response form.
1. I have list of total employees.
2. Response from employees who fill on daily basis.
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 @bhuvanasundar ,
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.
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
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
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?
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.
This will be a conference that you do not want to miss!
Don't miss the Power BI Dev Camp this week!
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.