Forum Discussion
Post ProdigyLast X MONTHS based on selected MONTH
Hi,
Try this:
SalesLastXMonths =
VAR SelectedMonth = MAX('Date'[Month]) -- Get the selected month
VAR SelectedYear = MAX('Date'[Year]) -- Get the selected year
VAR StartDate =
EDATE(DATE(SelectedYear, SelectedMonth, 1),
-6 )-- Adjust this value to show the last X months (e.g., -6 for 6 months)
RETURN
CALCULATE([TotalSales],FILTER(ALL('DateTable'),'DateTable'[Date] >= StartDate &&'DateTable'[Date] <= DATE(SelectedYear, SelectedMonth, 1) - 1))Hi,
I have solved a similar question in the attached file.
Hope this helps.
Super UserHi,
I have solved a similar question in the attached file.
Hope this helps.
Post ProdigyHi Ashish_Mathur ,
Thank you for your reply. Maybe I am missing something or a filter. How do I show the last six months, including the month that is selected. It is NOT showing in this selection.
- Ashish_Mathur
It works fine in the file that i shared with you. Please study it carefully and then apply those formulas.
- Oros
- Ashish_Mathur
You are welcome.