cancel
Showing results for
Did you mean:
Helper IV

## 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,month

can someone help.

thanks

kg

1 ACCEPTED SOLUTION

Accepted Solutions
Super User IV

@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!

19 REPLIES 19
Memorable Member
``````Next month value = calculate(sum('table'[total hours value]),DATESINPERIOD(DimDate[Date],MAX(DimDate[Date]),1,MONTH))

``````

Try use this.

Super User IV

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://www.archerpoint.com/blog/Posts/creating-date-table-power-bi
https://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...

Proud to be a Super User!

Super User II

Create a measure as follows:

next month sales = CALCULATE(SUM(ClothingSales[Sales]), DATEADD(ClothingSales[Date], 1, MONTH))

Just use your dates column in above dax.

Thanks,
Pragati

If this helps, Appreciate a KUDOS!

Proud to be a Super User!

Helper IV

Amit

I tried

Next month = CALCULATE(SUM('Sales- Hours'[Total Hours Value]),DATESMTD(DATEADD('calender'[Month Year],1,MONTH)))

Next month . = CALCULATE(SUM('Sales - Hours'[Total Hours Value]),DATESINPERIOD('calender'[Month Year],MAX('Table'[Month Year]),1,MONTH))
Both are bringing same values ...
Its not working.. means not matching my aug month value.

Thanks
Kavitha Ghosh
Helper IV

Thanks Pragati..its not working

Helper IV

Thanks Farhan..Its not working

Super User II

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

If this helps, Appreciate a KUDOS!

Proud to be a Super User!

Helper IV

Its still showing July values not aug values

Super User IV

@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

Proud to be a Super User!

Announcements

#### Power Platform Community Conference

Check out the on demand sessions that are available now!

#### Microsoft Power Platform Communities

Check out the Winners!

#### Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors