Forum Discussion
Wresen
9 months agoPost Patron
Add 2 year to a date , Measure
Hi and thx for reading this.
I am in a bit of a brain freez and cant find an easy good solution to this
I have a date table with dates
2025-11-02
2016-12-22
I just want to make an easy mesaure that adds (lets say 2 years) to this date.
so if i put them togater in i table i get,
( in the end i want to use this in a slicer so i can change years as i want)
Thx so much
= EDATE( YourDateColumn,24)
3 Replies
- AhmedxSuper User
= EDATE( YourDateColumn,24)
- amitchandakSuper User
Wresen ,
New column
= Date(Year([Date])+2, Month([Date]) , Day([Date]) )
Date as Dateadd
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827