Forum Discussion
Measure + Date
Hello I need to create measures enabling me to obtain the sum of my sales : - the current month -2 months from last year (for example, it's November 2023 and I want to display my total sales for ...
sales for current month -14 months
var a = min(date[date]) -- to get the minimum selected Date
_StartDate = EDATE(a,-14) -- startdate Before 14 months
_Enddate = EOMONTH (_StartDate,0) -- EndDate of 14th month
return calculate(sum[Sales],FILTER(ALL('Date'),'Date'[Date] >=_StartDate && 'Date'[Date] <= _Enddate))
use the above same measure for previous one moth sales calculation just replace -14 with -1
for current month directly use
sales = sum[Sales]