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 ta...
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")

     

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")