topic Re: Power BI Desktop in Developer

Power BI Desktop

Sanketmahore — Tue, 22 Mar 2022 20:49:37 GMT

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

Re: Power BI Desktop

Sanketmahore — Mon, 21 Mar 2022 19:35:03 GMT

Participant Identifier and employee email can be joined

Re: Power BI Desktop

V-lianl-msft — Thu, 24 Mar 2022 02:17:27 GMT

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.

Re: Power BI Desktop

Sanketmahore — Thu, 24 Mar 2022 06:17:56 GMT

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