Measure + Date

[Charline_74]

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 September 2022)
- the last month of last year (e.g. it's 2023, I want to display my total sales for December 2022)
- the current month -1 month (e.g. it's November 2023, I want to display my total sales for October 2023)
- the current month

I need these measures to be dynamic.

I have a table with a sales column and a date column.

[Anonymous]

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]