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
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
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
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 38 members 965 guests
Please welcome our newest community members: