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")
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
You cannot use DateAdd with Measure....
You need to create calculated column to get the next month Value.
Create a new Table name it "Date" using "CalendarAuto()"
Now Join this date with your Table (MonthYear and Date)
Mark this new date table as "Date Table"
Create measure to calculate next month value
Next month value = calculate(sum('table'[total hours value]),DATESINPERIOD(DimDate[Date],MAX(DimDate[Date]),1,MONTH))