Forum Discussion

wolfboyjan's avatar
wolfboyjan
New Member
3 years ago

Creating an Index in Power BI - help with calculating based on current row value

I'm trying to create an Index of times, to show whether individual runners are getting faster or slower over time, with a runner's first time as 100.0 and any decrease in future times being expressed...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
3 years ago

Hi,

These calculated column formulas should answer the first 2 questions

Earliest date of runner = CALCULATE(MIN(Data[event_date]),FILTER(Data,Data[runner_name]=EARLIER(Data[runner_name])))
Time at earliest date = LOOKUPVALUE(Data[runner_time],Data[event_date],Data[Earliest date of runner],Data[runner_name],Data[runner_name])

Hope this helps.

Chris_Kennedy's avatar
Chris_Kennedy
Frequent Visitor
3 years ago

Thank you for your help and time. I tried to implement this but received the error: "A table of multiple values was supplied where a single value was expected." when I try to create the Time at earliest date column". 

 

Unfortunately I can't see any more detail about which column is generating this error. 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    3 years ago

    You are welcome.  Share the download link of the PBI file.  Show the problem and expected result clearly.