Forum Discussion

AuroraNI's avatar
AuroraNI
Icon for Helper III rankHelper III
6 years ago
Solved

difference based on dynamic rank

Hi, I have the below table in PBI and I would like another column in this table that calculates the time differences between 1st place and all the other runners, and this would change based on the e...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    5 years ago

    AuroraNI 

     

    Thanks for the file. It made things easier.

    This works:

     

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

AuroraNI , Create a new column like

New colum =

var _1 = minx(filter(Table, event =earlier([event]) && [Time] > earlier([Time])), [Time])

return

if(isblank( _1),0, _1 -[Time])