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")

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")

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Amit,

        Thanks a ton.

        here is my solution.

         

        NEXT MONTH = FORMAT(EOMONTH(TODAY(),1),"MMM YYYY")
         
        NEXT month HOURS = CALCULATE(SUM('Sales - Hours'[Total Hours Value]),FILTER('Sales - Hours','Sales - Hours'[Month Year]=DATEVALUE([NEXT MONTH])))
         
         
         
        Thanks again