Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

NEXTMONTH() function issue

Dear all,         I was using the next month function to create a column as Opening Balance. But the same is not getting populated for the latest month in the column. Please refer the screenshot for...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    NEXTMONTH returns a table that contains a column of all dates from the next month, based on the first date in the dates column in the current context.  Because your current table does not contain dates from July onwards, the last row appears blank.

     

    You can use the following calculated column:

     

     

    Opening Bal Cal = EDATE(Sheet[Period Cal],1)

     

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

Anonymous's avatar
Anonymous
Not applicable
5 years ago

3 rd column is the expected output and 5 th column is the actual output on using the dax. amitchandak  Greg_Deckler . It would be great if you could help me. Thanks in advance

amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous ,

This is 2nd and 3rd column

Period = Date(right([period],4), left([period],2),1)
Opening Balance = eomonth([period],0) +1

 

Hope I got it correctly