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")
Thanks Pragati..its not working
Hi Anonymous ,
Your comment - Not working doesn't give me any insight on what is wrong with it.
Always helpful to have some screesnhot with error.
Thanks,
Pragati
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
Hi Anonymous ,
There is an existing thread for the exact same issue:
https://community.powerbi.com/t5/Desktop/Sales-Sum-of-next-month/td-p/376981
Thanks,
Pragati