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 ,

 

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

Hi

this is my actual problem.

Thanks

Kg

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , That is wrong, why are you using month year in dateadd function. 

    you need to use date. Same has been provided in all formulas 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Still same

       

      • amitchandak's avatar
        amitchandak
        Super User
        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")