Convert Formula to Power Query

Inuque Daspliy 0 Reputation points
2023-10-16T15:26:17.0633333+00:00

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!

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