Forum Discussion
Dynamic Date Title
Hi, I want to insert years as a title into a card. Like shown in the picture. The last card "2022" is always this year. I did this with the formula "=NOW()" Each year the title should change to...
If you want a date you a year ago you can create the following measure:
Date a Year Ago = DATE(YEAR(TODAY())-1,MONTH(TODAY()), DAY(TODAY()))
Hi Anonymous,
Try using the PREVIOUSYEAR() function along with the YEAR().
Here's the documentation: PREVIOUSYEAR function (DAX) - DAX | Microsoft Docs
I hope it helps