Forum Discussion
Countifs replicate Excel
=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, ...
jaltoft , Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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 |