The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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])
Solved! Go to Solution.
Instead of using the Date column, use TODAY(), EOMONTH(TODAY(), -1) and EOMONTH(TODAY(), -12)
Instead of using the Date column, use TODAY(), EOMONTH(TODAY(), -1) and EOMONTH(TODAY(), -12)
User | Count |
---|---|
25 | |
10 | |
8 | |
7 | |
6 |
User | Count |
---|---|
32 | |
12 | |
10 | |
10 | |
9 |