Forum Discussion

H_Jones's avatar
H_Jones
Icon for Helper I rankHelper I
10 years ago

Date Filter in New Measure

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 t...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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,