Nextmonth calculation

[Anonymous]

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

[Pragati11]

Hi @Anonymous ,

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

[Anonymous]

Thanks Pragati..its not working

[Anonymous]

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

[FarhanAhmed]

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

[Pragati11]

Hi @Anonymous ,

You can use following measure to get next month value:

Next month = DATEADD(ClothingSales[Date], 1, MONTH)

Replace ClothingSales[Date]  in above dax with your date column.

Also, please try tagging people you are trying to respond from next time.

Thanks,

Pragati

[Anonymous]

Hi

this is my actual problem.

Thanks

Kg

[amitchandak]

@Anonymous , That is wrong, why are you using month year in dateadd function. 

you need to use date. Same has been provided in all formulas 

[Anonymous]

Still same

[amitchandak · Accepted solution]

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

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

[Anonymous]

Amit,

Thanks a ton.

here is my solution.

NEXT MONTH = FORMAT(EOMONTH(TODAY(),1),"MMM YYYY")

NEXT month HOURS = CALCULATE(SUM('Sales - Hours'[Total Hours Value]),FILTER('Sales - Hours','Sales - Hours'[Month Year]=DATEVALUE([NEXT MONTH])))

Thanks again

[Pragati11]

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

[Anonymous]

Its still showing July values not aug values

[Pragati11]

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

[amitchandak]

@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

[Anonymous]

Amit,

Date only

[amitchandak]

@Anonymous ,

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-YTD-LYTD-Week-Over-Week/m-p/1051626#M184


Appreciate your Kudos.

[Anonymous]

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

[FarhanAhmed]

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

Try use this.

[Anonymous]

Thanks Farhan..Its not working