Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
57 | |
21 | |
19 | |
17 | |
16 |
User | Count |
---|---|
85 | |
80 | |
52 | |
37 | |
22 |