topic Next months in DAX Commands and Tips

Next months

Anonymous — Fri, 17 Mar 2023 10:45:10 GMT

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

Re: Next months

tamerj1 — Fri, 17 Mar 2023 10:54:09 GMT

Hi Anonymous
Please try

EDATE ( [Date], [Month] )

Re: Next months

Anonymous — Fri, 17 Mar 2023 10:57:05 GMT

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

Re: Next months

KeyurPatel14 — Fri, 17 Mar 2023 11:08:21 GMT

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.