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

FarhanAhmed's avatar
FarhanAhmed
Community Champion
6 years ago
Next month value = calculate(sum('table'[total hours value]),DATESINPERIOD(DimDate[Date],MAX(DimDate[Date]),1,MONTH))

 

Try use this.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks Farhan..Its not working