Forum Discussion

nirrobi's avatar
nirrobi
Helper V
10 years ago
Solved

Check for 2 condition for every line

Hi All,

 

I have to check for every line if:

1- it is the last status date regarding every FILE (column A)

AND

2- if the status id is F (column C)

 

in reality, the answers for the attached table are the green lines --> the last status and the status id is F.

 

thanks in advanced.

 

Nir.

 

 

Need Help
  • KGrice's avatar
    KGrice
    10 years ago

    Hi nirrobi. Try this as a calculated column:

     

    Column = (TableName[Status Date]=CALCULATE(MAX(TableName[Status Date]), FILTER(ALL(TableName), TableName[File]=EARLIER(TableName[File])))) 
	&& (TableName[Status ID]="F")

     

2 Replies

  • KGrice's avatar
    KGrice
    Memorable Member
    10 years ago

    Hi nirrobi. Try this as a calculated column:

     

    Column = (TableName[Status Date]=CALCULATE(MAX(TableName[Status Date]), FILTER(ALL(TableName), TableName[File]=EARLIER(TableName[File])))) 
	&& (TableName[Status ID]="F")