NEXTMONTH() function issue

[Anonymous]

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 the DAX used and column  

[VijayP]

@Anonymous 

Change "Period Cal" Data Type to Date and see whether it is working

if this is the solution then mark this as solution and share your Kudos

Regards

Vijay Perepa

[Anonymous]

Dear Vijay, Thanks for the reply but all the columns displayed are in date format and only the frst field Tax Period is in text datatype

[VijayP]

@Anonymous 

What should be the latest month in the above example (Result)

The Right function is doing some thing odd!

[Anonymous]

3 rd column is the expected output vijay.

[Anonymous]

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

[v-deddai1-msft · Accepted solution]

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

[amitchandak]

@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