Forum Discussion

admin11's avatar
admin11
Icon for Memorable Member rankMemorable Member
5 years ago
Solved

How to increase the value automatically monthly increase by 1 digit ?

Hi All   I have below expression working fine :- Show Last 24 Month = IF ('Date'[Date] >= EDATE(TODAY(),-25), 1, 0)   But next month i need to change 25 to 26   May i know it there a way to a...
Need Help
  • admin11's avatar
    admin11
    5 years ago

    v-xiaotang 

    Thank you very much . I will try it out soon

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

admin11 , I think you are starting from fix date of 1 April 2019

 

Show Last 24 Month = IF ('Date'[Date] >= date(2019,04,01) , 1, 0)