Next months

[Anonymous]

Hi,

I have two columns, Date and the numbers of month. I want to calculate a next month column.

Example: Date 01.01.2023 plus 2 months = 01.03.2023

Date	Month	Next months
01.01.2023	2	01.03.2023
01.05.2023	3	01.08.2023
01.10.2023	5	01.02.2023

I tried NEXTMONTH(), but this does not work because of mutiple values. Is there a way to get the next months without multiplying with 30?

Appreciate any ideas. Thanks

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

EDATE ( [Date], [Month] )

[KeyurPatel14 · Accepted solution]

Hi @Anonymous ,
You can use EDATE() DAX Function to solve your problem.
If this helps then please give it a kudos and mark it as a solution.
Thank you.

[tamerj1 · Accepted solution]

Hi @Anonymous 
Please try

EDATE ( [Date], [Month] )

[Anonymous]

Ohhhh, it works. Thank you, my BI hero 😁