Forum Discussion

senthil_venkat's avatar
senthil_venkat
Frequent Visitor
6 years ago

NextMonth and Next Quarter ()

Hi All, I have a excel table which has due date. I am trying to identify the which all the rows that will be due in next month using the NextMonth(). But I am getting below error message. Can someone...
tMonth
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

NEXTMONTH() works a bit different from what you expect.

 

https://docs.microsoft.com/en-us/dax/nextmonth-function-dax

 

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.

 

You need to test if your Filing Due Date is in the NEXTMONTH() table.

 

DueNextMonth := 'EFSS Entities'[Filing Due Date] IN NEXTMONTH(Dates[date])

 

senthil_venkat's avatar
senthil_venkat
Frequent Visitor
6 years ago

Hi,

 

I am not seeing the expected results. I am getting just "False" for every row. Include July rows

 

I did try using  DateAdd function, but many rows are having blank values.  Any thoughts how to fix? 

 

DueNextQtr = (DateAdd('EFSS Entities'[Filing Due Date],1,QUARTER))
 
 
 
 
 
 
 
 
 
 

 

 

 

 

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    Did you link in your Dates table?  Or do you want to compare to "Today"  only?

    • senthil_venkat's avatar
      senthil_venkat
      Frequent Visitor
      6 years ago

      I am not using any dates table. Just need to compare the filing date to Today's date and list out which are the rows that will be due next month and next quarter.