Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Next months

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....
  • tamerj1's avatar
    tamerj1
    3 years ago

    Hi Anonymous 
    Please try

    EDATE ( [Date], [Month] )

  • KeyurPatel14's avatar
    KeyurPatel14
    3 years ago

    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's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
3 years ago

Hi Anonymous 
Please try

EDATE ( [Date], [Month] )

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

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