Need help with an IF formula

[dsabsi]

Hi guys, 

I need your help with creating an IF-formula in Power BI which shows me the following situation:

IF two names are beneath each other AND in the next column for the same rows , there is atleast ONE Yes, then show me "Check is done" .. IF that's not true show me "Check is not done" .

To illustrate this so that i'm clear, see the below print screen, I want to have the text in the third column 

All my columns have the text format. 

Many Thanks!!, 

DSabsi

[Anonymous · Accepted solution]

Hi @dsabsi

Try the following

1. Add an index column from 1 using the query editor.

2. Create a column in your table as

Status = IF (Calculate(DistinctCOUNT((DoneorNot[CheckDone]))+0, Filter(DoneorNot,DoneorNot[CheckDone]= "Yes" && EARLIER(DoneorNot[Name]) = DoneorNot[Name])) >0,"Check is done", "Check is not Done" )

3. Now plot the table using Index, Name, CheckDone, Status

Sample screen shot

If this works for you please accept this as a solution adn also give KUDOS.

Cheers

CheeenuSing

[dsabsi]

Many thanks!! @Anonymous