Forum Discussion
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...
Anonymous , This wrong usgaes. If you need just to diaply next month use this
next month = format(eomonth(today(),1),"MMM-YYYY")
Its still showing July values not aug values
Anonymous , Few things.
1) Your data table should be marked as a date table.
2. Hope Jul 2020 is the month on the page. If not then time intelligence will pick up last month of the calendar
Amit,
Date only