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

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

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,099,018
Messages
5,466,073
Members
406,463
Latest member
vstruggs

This Week's Hot Topics

Top