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 amitchandak essentially what I need to do is mark Y if the customer has previously been contacted in the last 12 months.
