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

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

7 Replies

  • VijayP's avatar
    VijayP
    Community Champion
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        VijayP
        Community Champion
        5 years ago

        Anonymous 

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

        The Right function is doing some thing odd!