Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Diego_Vialle
Helper II
Helper II

DAX - Fixed dates for card

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])

 

Diego_Vialle_0-1654786438980.png

 

1 ACCEPTED SOLUTION
johnt75
Super User
Super User

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

View solution in original post

1 REPLY 1
johnt75
Super User
Super User

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.