Forum Discussion

Charline_74's avatar
Charline_74
Resolver I
2 years ago

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 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.

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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]