Forum Discussion

PrachiD's avatar
PrachiD
Helper I
8 years ago
Solved

Calculate Time Statisctics

Hello All, I m trying to calculate the In time and out time of Emp. The problem is that a single person can do multiple times IN/OUT but I want to calculate only his First IN and  Last Out....
General Comment
Interesting Links
Need Help
Show and Tell
Tutorial Requests
  • v-yuta-msft's avatar
    v-yuta-msft
    8 years ago

    Hi PrachiD,

     

    Based on your description, you want to achieve max time in a day filtered by column [begin_date], right?

     

    To achieve your requirement, please create a calculate column and use DAX formula below:

    Expected Column =

    var maxTime = CALCULATE(MAX(data[time]), FILTER(ALL(data), data[emp_id] = EARLIER(data[emp_id]) && data[begin_date] = EARLIER(data[begin_date])))

    return

    IF(data[time] = maxTime, data[Time_Statistics_out], BLANK())

     

    The result is like below and you can refer to PBIX file here:

    https://www.dropbox.com/s/kvfd4rwa8paenz9/For%20PrachiD.pbix?dl=0

     

    Best Regards,

    Jimmy Tao

v-yuta-msft's avatar
v-yuta-msft
Community Support
8 years ago

Hi PrachiD,

 

Based on your description, you want to achieve max time in a day filtered by column [begin_date], right?

 

To achieve your requirement, please create a calculate column and use DAX formula below:

Expected Column =

var maxTime = CALCULATE(MAX(data[time]), FILTER(ALL(data), data[emp_id] = EARLIER(data[emp_id]) && data[begin_date] = EARLIER(data[begin_date])))

return

IF(data[time] = maxTime, data[Time_Statistics_out], BLANK())

 

The result is like below and you can refer to PBIX file here:

https://www.dropbox.com/s/kvfd4rwa8paenz9/For%20PrachiD.pbix?dl=0

 

Best Regards,

Jimmy Tao

  • PrachiD's avatar
    PrachiD
    Helper I
    8 years ago

    Thank You so much :smileyhappy: