Forum Discussion
Count earliest time
dears,
good day!!
i have a table that has a column called time_commet and i would like to count only earliest time for each employee how can i do that ??
Hi 160475 ,
Please try some formulas like the following:
earliest time = CALCULATE ( MIN ( 'table'[time_comment] ), FILTER ( 'table', [employee] = EARLIER ( 'table'[employee] ) ) )measure:
earliest time = CALCULATE ( MIN ( 'table'[time_comment] ), FILTER ( 'table', [employee] = SELECTEDVALUE ( 'table'[employee] ) ) )If this does not work, please share some example data and expect result.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
160475 , what do mean by count of earliest
In my blog use min and firstnonblankvalue in place of Max and lastnonblankvalue
https://amitchandak.medium.com/power-bi-get-the-last-latest-value-of-a-category-d0cf2fcf92d0
Hi 160475 ,
Please try some formulas like the following:
earliest time = CALCULATE ( MIN ( 'table'[time_comment] ), FILTER ( 'table', [employee] = EARLIER ( 'table'[employee] ) ) )measure:
earliest time = CALCULATE ( MIN ( 'table'[time_comment] ), FILTER ( 'table', [employee] = SELECTEDVALUE ( 'table'[employee] ) ) )If this does not work, please share some example data and expect result.
Best Regards
Community Support Team _ chenwu zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
