If no previous row then

[Roym]

I have the below code who shows  in column the results based on the following logic:

1. If the test is effective, and the review is also effective -> Column= Effective

2. If test is effective, and review is Ineffective -> Column = Ineffective 

3. If the test is effective, and the review is Open -> Column = the review result from the previous assessment.

(Review is always prefered above the test result)

This works perfectly with the below code, only when it is the first row (based on the session id) it remains empty because the code can not find a previous result (which makes sense). What I kind of need to do is add a condition to check if the current row is the first row and if so, then show the 'test result'.  I'm only not sure how to do this, so hopefully someone can give me some guidance on how to achieve this. Thanks!!

Column =
var _previosid=MAXX(filter('Table','Table'[session]=EARLIER('Table'[session])&& 'Table'[ID]< EARLIER('Table'[ID])),'Table'[ID])
var _review=CALCULATE(MAX('Table'[Review]),FILTER('Table','Table'[ID]=_previosid))
return
SWITCH(TRUE(),'Table'[Test]="Effective" && 'Table'[Review]="Effective","Effective",
'Table'[Test]="Effective" && 'Table'[Review]="Ineffective","Ineffective",
'Table'[Test]="Effective" && 'Table'[Review]="Open",_review)

[Roym]

@ryan_mayu Awesome, this works perfectly!! Thanks!!

[ryan_mayu]

you are welcome

[ryan_mayu · Accepted solution]

@Roym 

maybe you can try this

Column =
var _previosid=MAXX(filter('Table','Table'[session]=EARLIER('Table'[session])&& 'Table'[ID]< EARLIER('Table'[ID])),'Table'[ID])
var _review=CALCULATE(MAX('Table'[Review]),FILTER('Table','Table'[ID]=_previosid))
VAR _result=
SWITCH(TRUE(),'Table'[Test]="Effective" && 'Table'[Review]="Effective","Effective",
'Table'[Test]="Effective" && 'Table'[Review]="Ineffective","Ineffective",
'Table'[Test]="Effective" && 'Table'[Review]="Open",_review)

return if (_result="","test result",_result)