Forum Discussion
Calculate First Acquisition
Hi I have a requirement wherein I want to write a DAX that can calculate the New Acquisition of customers. For example, from the sample data below, steve has enrolled first on Feb 14, 2022 and thou...
Hi,
try this:
Measure =
var _earliestdate = calculate(min('Data'[first enrolled]),ALLEXCEPT(Data,Data[brand],Data[email],Data[market]))
return
CALCULATE(DISTINCTCOUNT(Data[email]))
-the bold part should bring back the date you require if you just want to see what it's doing,
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍