DAX - Fixed dates for card

[Diego_Vialle]

Hi, I need some help in DAX to automate 3 date cards.

The last card as shown in the image below, brings the current month. The middle card carries the previous month, and the first card carries the previous year of the current month.

MesAno Sigla = FORMAT(dCalendar[Date],"MMM")&"/"&YEAR(dCalendar[Date])

[johnt75 · Accepted solution]

Instead of using the Date column, use TODAY(), EOMONTH(TODAY(), -1) and EOMONTH(TODAY(), -12)