Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! 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")
Hi @ghosh_kavitha ,
Create a measure as follows:
Thanks Pragati..its not working
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
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))
Proud to be a Super User!
Hi @ghosh_kavitha ,
You can use following measure to get next month value:
Hi
this is my actual problem.
Thanks
Kg
@ghosh_kavitha , That is wrong, why are you using month year in dateadd function.
you need to use date. Same has been provided in all formulas
Still same
@ghosh_kavitha , This wrong usgaes. If you need just to diaply next month use this
next month = format(eomonth(today(),1),"MMM-YYYY")
Amit,
Thanks a ton.
here is my solution.
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
Its still showing July values not aug values
Hi @ghosh_kavitha ,
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
@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
Amit,
Date only
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.
Amit
I tried
Next month value = calculate(sum('table'[total hours value]),DATESINPERIOD(DimDate[Date],MAX(DimDate[Date]),1,MONTH))
Try use this.
Proud to be a Super User!
Thanks Farhan..Its not working
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |