Dynamic Date Title

[Nanaki]

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 the next year.
But I dont know how to set the title for the previous year and the title for two years ago. 
Is there a formula, with which i can just say: "Give me this year minus 1 year ? 

Thanks in advance. 
Best regards. 

[Anonymous]

Hi @Nanaki,

Try using the PREVIOUSYEAR() function along with the YEAR().

Here's the documentation: PREVIOUSYEAR function (DAX) - DAX | Microsoft Docs

I hope it helps

[amitchandak]

@Nanaki ,measure or column as per need

This Year = year(Today())

Next Year = year(Today()) +1

Last Year = year(Today()) -1

[Nanaki]

Thank you for your fast reply.
But I still get strangely 1905 for the last year. 

[Tahreem24]

@Nanaki  Can you share screen shot of your date column and check which data type it is. 

[Nanaki]

In the first picture you can see the formula "today" with the today date.

And in the 2. picture with "year(today)" i get the year 1905.

[PierrreVelraeds]

Hi @Nanaki,

13-7-1905 is the date value of number 2021. You can see this e.g. in Excel by changing the format into Short Date of a cell containing 2021.

I can reproduce the behaviour you experience when I create a new column instead of a measure

Defintions:

• Column Last Year = year(Today()) -1
• Last Year = year(Today()) -1

Solution is then to create a measure with that definition.

[Nanaki]

But with that solution I wont get the year 2021 in a date format right? Only in a number format ? 

[PierrreVelraeds · Accepted solution]

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()))

[Nanaki]

Awesome, this worked. Thank you very much to all of you!

[Nanaki]

I dont have a column, I just have this formula. I created it manually as a measure and wanted to insert it into one card.