Power BI Desktop

[Sanketmahore]

Hello everyone,

Hope you are doing well.

I have one urgent mystery to solve if anyone can help me with this it would be really great.

I have Google meet data set as displayed below and I need to find out participants who rarely get to speek with people from other departments and people who rarely turn on their video.

Please do let me know what trick I can use to find answer to both the questions 

I have attached screenshot of both the datasets .

 

 really looking forward to get answer on this as I really need this for project I need to deliver tomorrow.

Please do let me know in case of any clarification required from my end but hoping to get the answer soon

Please help 

•  

[V-lianl-msft]

Hi @Sanketmahore ,

Not very clear,Maybe you can try using the lookupvalue function.

If the problem persists, please delete the sensitive data and provide sample data and the expected results

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sanketmahore]

Mai I know where I can attach the dataset as I am not getting option to attach the files 

[Sanketmahore]

Participant Identifier and employee email can be joined