How to display the 5 previous month

[Anonymous]

Hi there,

I want to show the 5 previous months and the current one without using a slicer and update it automatically.

Data example bellow (assuming that Frebruary is the current month, I want to see the marked months and the current one);

[amitchandak]

Try

Var   _This_year(max(ENDOFMonth('Date'[Date Filer])) // OR use today
Var   _This_year=today()
Var _min_This_year= (maxx('Date',STARTOMONTH(DATEADD('Date'[Date Filer],-5,MONTH))))


Var   _This_year_val =CALCULATE(sum(Sales[Sales Amount]),(Sales[Sales Date])<=_This_year && (Sales[Sales Date]) >=_min_This_year)

[amitchandak]

 Or You can also refer https://community.powerbi.com/t5/Desktop/Sum-of-the-amount-of-sales-the-previous-5-months/m-p/808469...

---

@amitchandak wrote:

Try

Var   _This_year(max(ENDOFMonth('Date'[Date Filer])) // OR use today
Var   _This_year=today()
Var _min_This_year= (maxx('Date',STARTOMONTH(DATEADD('Date'[Date Filer],-5,MONTH))))


Var   _This_year_val =CALCULATE(sum(Sales[Sales Amount]),(Sales[Sales Date])<=_This_year && (Sales[Sales Date]) >=_min_This_year)

---