countif power query

[ajm]

I currently use a Countif formula within a nested if statement to determine whether the word "Description" appears in an adjacent cell. I have begun converting the whole thing to power query but am struggling with the ISNA COUNTIF section. My formula looks at the cell containing a text string and if the first two characters are "UW", or it was a number, or did not contain the word "Description", it did A, if not it does B.

IF Text.Start([Contract],2)="UW" OR Value.Is((Text.Start([Contract],1),type.number*1) OR[B] ISNA(COUNTIF([Description],"*Description*")[/B])),

You can see above, I have recreated the Left(Cell,2) and the isnumber for the first character part of the formula. But have been unable to determine the final piece looking for "Description". Please help

 

[RoryA]

Why would COUNTIF return #N/A in your formula?

Most likely you want to nest something like List.Count(List.Select(...)) = 0 in PQ