Forum Discussion

DanielV91's avatar
DanielV91
Frequent Visitor
8 years ago
Solved

Calculated column based on rows position

Having the above table where delta is the difference between curent timestamp and previous one, I want to calculate the column for the far right. Which function should I use, or how can I appro...
Need Help
Show and Tell
  • alexei7's avatar
    alexei7
    8 years ago

    Ah yeah, sorry.

     

    Try it with an equals sign as well as the "<":

     

    Column = "Observation "&CALCULATE(COUNTROWS(Table1),ALLEXCEPT(Table1,Table1[id]),Table1[timestamp]<=EARLIER(Table1[timestamp]),Table1[delta]>2)+1

     

    Alex

DanielV91's avatar
DanielV91
Frequent Visitor
8 years ago

 

alexei7 thanks for replying! It is very close, but the ones where delta is greater than 2 should have asigned the next number. 
Basically for the ones that I marked with red should be '2'.

alexei7's avatar
alexei7
Continued Contributor
8 years ago

Ah yeah, sorry.

 

Try it with an equals sign as well as the "<":

 

Column = "Observation "&CALCULATE(COUNTROWS(Table1),ALLEXCEPT(Table1,Table1[id]),Table1[timestamp]<=EARLIER(Table1[timestamp]),Table1[delta]>2)+1

 

Alex

  • DanielV91's avatar
    DanielV91
    Frequent Visitor
    8 years ago

    alexei7 Thank you! Works now.