Forum Discussion

dsabsi's avatar
dsabsi
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Need help with an IF formula

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...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

     

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    dsabsi
    Icon for Advocate I rankAdvocate I
    9 years ago

    Many thanks!! Anonymous