Forum Discussion
sabilahmed
Resolver I
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: ...
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)