Forum Discussion
Get next month data based on selected month
Hi Guys, In my report the requirement is I need to get sum of weeks based on selected month but the twist is I need to get next month sum of weeks. for e.g. If user selected May from Month filter ...
Hi Anonymous
The first thing to note is you'll have a problem if the user selects December. Your logic to add 1 to the month number (MonthOfYear) will give you month 13.
DAX has a function called DATEADD which is commonly used in scenarios like this.
Something like:
SelectedMonth + 1 = CALCULATE( SUM(ListingDelays_Response_Updated[Number of weeks]), DATEADD('Date', 1, MONTH) )
PaulOlding
Solution Sage
Solution SageHi Anonymous
The first thing to note is you'll have a problem if the user selects December. Your logic to add 1 to the month number (MonthOfYear) will give you month 13.
DAX has a function called DATEADD which is commonly used in scenarios like this.
Something like:
SelectedMonth + 1 =
CALCULATE(
SUM(ListingDelays_Response_Updated[Number of weeks]),
DATEADD('Date', 1, MONTH)
)
Hi PaulOlding,
Thanks for this, DateADD actually really helped.
Best Regards,
Thanks