Forum Discussion

Sanketmahore's avatar
Sanketmahore
Regular Visitor
4 years ago

Power BI Desktop

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 

 

 

 

 

 

 

  •  

3 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support

    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's avatar
      Sanketmahore
      Regular Visitor

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