Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
For my report, i need my title to show last month of today's date.
For example, if we are Oct. 1st 2020, my report title should be
2020-Sep
I have a date table where my lastdate is TODAY()
How can I create a measure for this?
Solved! Go to Solution.
Could you please try the following:
Measure = DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
Measure = FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())), "YYYY-MM")
Could you please try the following:
Measure = DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))
Measure = FORMAT(DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY())), "YYYY-MM")