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,month
can someone help.
Go to Solution.
@ghosh_kavitha , This wrong usgaes. If you need just to diaply next month use this
next month = format(eomonth(today(),1),"MMM-YYYY")
Proud to be a Super User!
View solution in original post
Next month value = calculate(sum('table'[total hours value]),DATESINPERIOD(DimDate[Date],MAX(DimDate[Date]),1,MONTH))
Try use this.
Next month value = CALCULATE(sum('table'[total hours value]),DATESMTD(dateadd('Date'[Date],1,MONTH)))
CALCULATE(sum('table'[total hours value]),nextmonth('Date'[Date]))
Use date table properly
To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer : https://radacad.com/creating-calendar-table-in-power-bi-using-dax-functions https://www.archerpoint.com/blog/Posts/creating-date-table-power-bihttps://www.sqlbi.com/articles/creating-a-simple-date-table-in-dax/See if my webinar on Time Intelligence can help: https://community.powerbi.com/t5/Webinars-and-Video-Gallery/PowerBI-Time-Intelligence-Calendar-WTD-Y...Appreciate your Kudos.
Hi @ghosh_kavitha ,
Create a measure as follows:
Thanks Pragati..its not working
Thanks Farhan..Its not working
Your comment - Not working doesn't give me any insight on what is wrong with it.
Always helpful to have some screesnhot with error.
Its still showing July values not aug values
@ghosh_kavitha , 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
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.