Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Nextmonth calculation

Hi, This is my table.I just want to calculate Aug month total hours value. I used this measure  Next month value = calculate(sum('table'[total hours value]),dateadd(table[month year],+1,mont...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , This wrong usgaes. If you need just to diaply next month use this 

    next month = format(eomonth(today(),1),"MMM-YYYY")

Pragati11's avatar
Pragati11
Super User
6 years ago

Hi Anonymous ,

 

Create a measure as follows:

next month sales = CALCULATE(SUM(ClothingSales[Sales]), DATEADD(ClothingSales[Date], 1, MONTH))
 
Just use your dates column in above dax.
 
Thanks,
Pragati
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Pragati..its not working

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi Anonymous ,

       

      Your comment - Not working doesn't give me any insight on what is wrong with it.

      Always helpful to have some screesnhot with error.

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Its still showing July values not aug values

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Can you help me to calculate the next month measure alone.

       

      ans should be "Aug 2020".

       

      i tried Next month = month(today()+1)

      the ans was "8"..but i need Aug 2020

       

      Thanks

      Kg

      • Pragati11's avatar
        Pragati11
        Super User
        6 years ago

        Hi Anonymous ,

         

        You can use following measure to get next month value:

        Next month = DATEADD(ClothingSales[Date], 1, MONTH)
         
        Replace ClothingSales[Date]  in above dax with your date column.
         
        Also, please try tagging people you are trying to respond from next time.
         
        Thanks,
        Pragati