For today I'm using
Today= DATE(YEAR(NOW()),MONTH(NOW()), DAY(NOW())
How would I display Today last year? I was thinking
TodayPrevYear = DATE(YEAR(NOW()-1),MONTH(NOW()), DAY(NOW())
But I get an error.
Can someone show me the correct formula to use for Today Last year?
Go to Solution.
Perhaps something like:
Measure = DATE(YEAR(NOW())-1,MONTH(NOW()), DAY(NOW()-1))
Proud to be a Datanaut!
You have to subtract 1 from the result of the YEAR function not inside the argument!
If you do YEAR ( NOW()-1 ) as you you've done you are basically asking for the function to return the YEAR of NOW()-1
which would be yesterday this year - thats why you have to get the year first and then subtract 1
TodayPrevYear = DATE ( YEAR ( NOW () ) - 1, MONTH ( NOW () ), DAY ( NOW () ) )
And same if you want yesterday previous year
Obviously for Day it won't matter if you subtract 1 inside or not
YesterdayPrevYear = DATE ( YEAR ( NOW () ) - 1, MONTH ( NOW () ), DAY ( NOW () ) - 1 )
Hope this helps!
Hi, You can also obtain:
Today-inPreviousYear = EDATE(TODAY(),-12)
Yesterday-inPreviousYear = EDATE(TODAY(),-12)-1
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
We spoke with Power BI Super User, Greg Deckler, about his charity work
Continue your learning in our online communities.