Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate No response

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: ...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous ,

     

    Can you pls share sample data and how does your data model look like.

     

    Regards,

    Harsh Nathani

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Anonymous 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.