Countifs replicate Excel

[jaltoft]

=IF([This Week''s Contacts]="","",IF(COUNTIFS($G:$G,[Cust No],$T:$T,"<"&[Start Date],$T:$T,">="&EOMONTH([Start Date],-12)+1)>=1,"Y",""))

Column G = Cust number

Column T = Start date

Hello,

I want to replicate the above Excel formulae within a a DAX calculated column  within my Power BI model can anyone please help?

[amitchandak]

@jaltoft , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[jaltoft]

@amitchandak  essentially what I need to do is mark Y if the customer has previously been contacted in the last 12 months.

[jaltoft]

Hello @amitchandak 

This is an example of what the data would look like and I want to replicate the column Contact in 12 months -

So the forumlae in excel I need to replicate in a DAX calculated column is =IF(A2="","",IF(COUNTIFS($B$2:$B$12,B2,$C$2:$C$12,"<"&C2,$C$2:$C$12,">="&EOMONTH(C2,-12)+1)>=1,"Y",""))

The columns are A-D in this version

This Weeks Contacts	Client No	Start Date	Contact 12 Months
Y	1234	15/10/2020	Y
Y	1233	15/10/2020	Y
	1111	12/10/2020
Y	1888	15/10/2020	Y
Y	8952	12/10/2020
Y	2535	11/10/2020
Y	1234	10/09/2020
Y	1233	08/08/2020
Y	1111	07/08/2020
Y	1888	06/06/2020
Y	9255	01/06/2019