cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper IV
Helper IV

Nextmonth calculation

Hi,

ghosh_kavitha_0-1594980302434.png

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

@ghosh_kavitha , This wrong usgaes. If you need just to diaply next month use this 

next month = format(eomonth(today(),1),"MMM-YYYY")



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

19 REPLIES 19
Memorable Member
Memorable Member

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

 

Try use this.

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Super User IV
Super User IV

@ghosh_kavitha ,

 

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-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...


Appreciate your Kudos.



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Super User II
Super User II

Hi @ghosh_kavitha ,

 

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!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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

Thanks Pragati..its not working

Thanks Farhan..Its not working

Hi @ghosh_kavitha ,

 

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!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

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