Convert Formula to Power Query

Inuque Daspliy 0 Reputation points

I want to add a custom column in power query so I can filter the results for the final output. The normal excel formula is:

=IF(AND(COUNTIF([XX DI],[@[XX DI]])>1, SUMPRODUCT(--(COUNTIFS([XX DI], [@[XX DI]], [Type], "")>0))), "Yes","No")

Please help!

A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,541 questions
0 comments No comments
{count} votes