Forum Discussion

SmailBelkhiri's avatar
SmailBelkhiri
Regular Visitor
2 years ago

finding the average of minimum values

Hi 

i have a table , with  salesmanid , BUID , date , start_Time , and Finish Time

i have many salesman , with many rows in a one day , i m looking to know what is the average of the minimim time for all my sales man . or by salesman.

in Excel , i add a new colomn indicate : if the time is the minimum  , but i cant do it in PowerBI

i attached an example of my data bellow 

My Example to download 

 

Thank You

1 Reply