Date Filter in New Measure

[H_Jones]

Hi,

Im trying to do a count with a condition on the date.

I want to count people who have a date in the 'Acquisition_Date' column thats before 24 months from the current date - so i want to the cut off date to update with every month that passes and not to be fixed. i.e. they have been a customer for at least 2 years. I cant find how to reference 'today'.

I would also like to add into this formula that another column ('Value_Change') is '>0'.

Please help 🙂

[v-sihou-msft]

Hi H_Jones,

If I understand your question correctly, you want to filter the Users which the 'Acquisition_Date' is at least two years ago based on current date. In DAX, you can use TODAY() function to reference 'today'. So your filter expression can be like:

FILTER ('User', DATEADD('User'[Acquisition_Date],2,year) < TODAY() )

Regards,

[MattAllington]

Are you sure you want today?  It seems to me that you should be using a date in the calendar that is 2 years after the acquisition date. That way the answer is still the same regardless what today's date is.