Forum Discussion
Combining Contains() & Datesbetween()
Hi guys, I have a sample table which show Active Customers based on Date below: Here, if I want to count the number of customers who are still here after 1 year, the formula is: Prev1...
henryvu93,
Create a count column using DAX below. And set its value to 1 in visual level filters.
Count = IF('Sample'[DIFF]>=10 && 'Sample'[DIFF]<=12,1,0)
Regards,
Lydia