Forum Discussion

alevandenes's avatar
alevandenes
Icon for Helper IV rankHelper IV
3 years ago
Solved

Subtract one month from date column

Hi Community,   I need to create a calculated column that subtracts one month from an Invoice date column. The formula needs to be valid also for the change of the year.   [DATEADD works but onl...
Need Help
  • v-jingzhang's avatar
    v-jingzhang
    3 years ago

    Hi alevandenes

     

    Try using EDATE function (DAX)

    Column = EDATE([Date],-1)

     

    Best Regards,
    Community Support Team _ Jing
    If this post helps, please Accept it as Solution to help other members find it.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Take a month from a date column like this: 
var Month_Name = Month(Datecolumn_name)
return Month_name-1
OR 

You can also use Previous Month Function

  • alevandenes's avatar
    alevandenes
    Icon for Helper IV rankHelper IV
    3 years ago

    This doesnt work as it is only taking the month number minuts one.

    it doesnt account for change of the year

     

    thanks anyways