Subtract one month from date column

[alevandenes]

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 only for a couple of rows..not sure why]

Can someone help me out here?

Thanks in advance

[v-jingzhang · Accepted solution]

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.

[CLQ]

I don't quite understand, you can use the function: Month('ColumnName')

or, if you want year and month number, something like:

concatenate(year(ColumnName),
month(ColumnName)).

(and in the event that you always want a leading zero, an if >0 and another concatenate would be nice)

I don't know if it's what you were looking for. If you can give an example, better 😁

[KNP]

DATEADD is the correct function to use.

Please provide some sample data, pasted as data.

Please explain what happens for the rows it is not working for. 

[Nofil098]

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]

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

it doesnt account for change of the year

thanks anyways

[vaibhavkale570]

Have you tried PREVIOUSEMONTH dax function?

[alevandenes]

apparently it doesnt work with a table, but only with a single value specified