cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
unclejemima Member
Member

Yesterday last year DAX formula

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?

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Yesterday last year DAX formula

Perhaps something like: 

 

Measure = DATE(YEAR(NOW())-1,MONTH(NOW()), DAY(NOW()-1))

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Sean Super Contributor
Super Contributor

Re: Yesterday last year DAX formula

@unclejemima

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! Smiley Happy

Vvelarde Super Contributor
Super Contributor

Re: Yesterday last year DAX formula

@unclejemima

 

Hi, You can also obtain:

 

Today-inPreviousYear = EDATE(TODAY(),-12)

Yesterday-inPreviousYear = EDATE(TODAY(),-12)-1




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




3 REPLIES 3
Highlighted
Super User
Super User

Re: Yesterday last year DAX formula

Perhaps something like: 

 

Measure = DATE(YEAR(NOW())-1,MONTH(NOW()), DAY(NOW()-1))

I have book! Learn Power BI from Packt


Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Sean Super Contributor
Super Contributor

Re: Yesterday last year DAX formula

@unclejemima

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! Smiley Happy

Vvelarde Super Contributor
Super Contributor

Re: Yesterday last year DAX formula

@unclejemima

 

Hi, You can also obtain:

 

Today-inPreviousYear = EDATE(TODAY(),-12)

Yesterday-inPreviousYear = EDATE(TODAY(),-12)-1




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 94 members 1,650 guests
Please welcome our newest community members: