how to write this qlikview expression in Power BI ?

[AnandRanga]

this expression is written in qlikview:

=FirstSortedValue(WHour,Aggr(Sum(WHour),TRANSDATE,WORKERNAME))

in this expression in I am showing the value of WHour field that contains numeric value, on the basis of  TRANSDATE,WORKERNAME column. 

I dont know how to write this same expression in power BI ?

[v-yuezhe-msft]

Hi @AnandRanga,

I am not familiar about functions in qlikview. Could you please post the raw data of your table and result after executing the above expression.

It seems that you would need to use RANKX function in Power BI Desktop.

Thanks,
Lydia Zhang