Excel formula to Power BI DAX

[RodrigoFinguer]

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?

[TABLE="width: 500"]
<tbody>[TR]
[TD]Formula Excel[/TD]
[/TR]
[TR]
[TD]=SUMPRODUCT((COUNTIFS(M3:M16,M3:M16,N3:N16,P3-1)=0)* ((N3:N16=P3)+(N3:N16=P3-1)))[/TD]
[/TR]
</tbody>[/TABLE]

Thanks!!!

 

[peter789]

Unless someone is smarter than me would me it help if if you provided sample data with expected result.

 

[RodrigoFinguer]

Unless someone is smarter than me would me it help if if you provided sample data with expected result.

Sorry, Take a look at this my other thread: https://www.mrexcel.com/forum/excel-questions/1085048-count-new-entries-dates-2.html

Look at the post #19