Need Help Writing Formula To Create Date

[colettb]

Hi Community!

I need help creating a formula for a New Column.  The result will be a date column based on another date column.

What I need to do is check today's date and create a column that contains January 1 of the year that is 4 years ago.

For example, If today is June 12, 2025, I want the formula to result in January 1, 2021. 

Another example is, if today is March 1, 2026, the result should be January 1, 2022.

Can someone help me with this?  I am a new Power BI user and have a lot to learn!

Thanks!

[Ashish_Excel]

Hi,

Try this calculated column formula

=date(year(Data[Date])-4,1,1)

Hope this helps.

[Shravan133 · Accepted solution]

FourYearsAgoJan1 =
DATE(YEAR(TODAY()) - 4, 1, 1)

Example outputs:

Today’s Date	Result
June 12, 2025	Jan 1, 2021
March 1, 2026	Jan 1, 2022