Forum Discussion
Solved
Need Help Writing Formula To Create Date
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!
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
2 Replies
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 Hi,
Try this calculated column formula
=date(year(Data[Date])-4,1,1)
Hope this helps.
