Forum Discussion

pardeepd84's avatar
pardeepd84
Icon for Helper III rankHelper III
5 years ago
Solved

Help with recreating excel formula

Hello,

 

I am trying to recreate an excel table in Power Bi, I have created formulas in excel for the same table but not sure how to replicate it in Power Bi.  

 

My dataset records the number of times employees go out to visit customers, on some occasions 2 employees will go to visit a customer.  Although 2 employees go to visit the same customer they may go seperately and therefore may arrive at separate times, what I need to do is record where employees arrive within 5 minutes of each other.

 

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi pardeepd84 ,

     

    Can you provide data in text or excel format?

     

    Best Regards,

    Jay

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi pardeepd84 ,

     

    Can you provide data in text or excel format?

     

    Best Regards,

    Jay