Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,694 questions
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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!