Forum Discussion

H_Jones's avatar
H_Jones
Helper 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 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 :)

2 Replies

  • MattAllington's avatar
    MattAllington
    Community Champion
    10 years ago

    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. 

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft 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,