Forum Discussion
Resolver IDATEADD with TODAY() column
Hi all,
I have a column:
Today = TODAY()
I then created a second column like this:
Today + 3 = DATEADD(Table[Today], 3, YEAR)
But this second column returns as blank as follows:
Why is this and is there a solution?
Cheers,
Sabil 🙂
sabilahmed , Check the suggestion from MarkVerwer first.
You need to use date as dateadd
date(Year([today])+3 , month([Today]) , day([Today]) )
Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827
3 Replies
- amitchandak
Super User
sabilahmed , Check the suggestion from MarkVerwer first.
You need to use date as dateadd
date(Year([today])+3 , month([Today]) , day([Today]) )
Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power-BI-Turning/ba-p/1187827 Is your table name "Table"?
try:
Today + 3 = DATEADD([Today], 3, YEAR)
sabilahmedThanks for replying MarkVerwer , unfortunately that came back as error.
amitchandak Thanks mate, your solution worked 🙂
