Excel formula to Power BI DAX

RodrigoFinguer

Board Regular
Joined
Jun 13, 2017
Messages
73
Hi everyone,

I have this formula on Excel and I would like to transform to Power Bi, I have already tried but with no success. Could anyone help me?

Formula Excel
=SUMPRODUCT((COUNTIFS(M3:M16,M3:M16,N3:N16,P3-1)=0)* ((N3:N16=P3)+(N3:N16=P3-1)))

<tbody>
</tbody>

Thanks!!!
 
Last edited:

Some videos you may like

Excel Facts

Square and cube roots
The =SQRT(25) is a square root. For a cube root, use =125^(1/3). For a fourth root, use =625^(1/4).

peter789

Board Regular
Joined
Nov 20, 2016
Messages
114
Unless someone is smarter than me would me it help if if you provided sample data with expected result.
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,102,334
Messages
5,486,223
Members
407,537
Latest member
Frank Nunez

This Week's Hot Topics

Top