Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago
Solved

Add years to a date column.

Good. I need to add a certain number of years to a column of dates. I have found solution with M language in query or through queries. I would like to know the solution through DAX since I want to do...
  • Ahmedx's avatar
    Ahmedx
    3 years ago

    pls try this

    Measure = 
VAR _Curentdate = SELECTEDVALUE('Table'[Date])
VAR _offset1 = MONTH(_Curentdate) *5 *12
VAR _offset2 = MONTH(_Curentdate)*2 *12
RETURN

SWITCH( TRUE(),
          _Curentdate>= DATE(2023,1,1), EDATE(_Curentdate,_offset1), EDATE(_Curentdate,_offset2))

Ahmedx's avatar
Ahmedx
Super User
3 years ago

pls try this

Column = 

VAR _offset1 = MONTH([Date]) *5 *12
VAR _offset2 = MONTH([Date]) *2 *12
RETURN

SWITCH( TRUE(),
            [Date]>= DATE(2023,1,1), EDATE([Date],_offset1), EDATE([Date],_offset2))