Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I wanted to display the last month with year in a card visual.
Suppose now it's Dec 2022, then it should display Nov 2022. If it's Jan 2023, it should display Dec 2022.
The format should be either "MMM YYYY" or full month name year.
Solved! Go to Solution.
Hi @Anonymous
Last Month = FORMAT(EOMONTH(TODAY(),-1), "MMMM /YYYY")
If you work with a data table and you want to filter you can also do something like:
Last Month = FORMAT(MAX(DimDate[Date]),-1), "MMMM /YYYY")
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
hi @Anonymous
try to plot with a column like this:
MMMYYYY = FORMAT(EDATE(TODAY(), -1), "MMM YYYYY")
Hi @Anonymous
Last Month = FORMAT(EOMONTH(TODAY(),-1), "MMMM /YYYY")
If you work with a data table and you want to filter you can also do something like:
Last Month = FORMAT(MAX(DimDate[Date]),-1), "MMMM /YYYY")
Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.
@Anonymous
Last Month = FORMAT(TODAY() - 1, "MMMM /YYYY")
@Anonymous
sorry, try this:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
142 | |
108 | |
101 | |
81 | |
74 |