cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dominaky Frequent Visitor
Frequent Visitor

DATEADD returns same value - cannot do YOY

Hello,

 

I'm a beginner with Power BI but I could not find an answer to my question. I have a database and want to show Year over Year for a metric. 

 

My sales data is coming from 'Sales_report'. I also have created a new table 'DATE' with the formula 'calendarauto'. 

I created two measures:

TOTAL SALES = Sum(sales_report[retail_qty])
LY TOTAL SALES = Calculate([TOTAL SALES], DATEADD('DATE'[DATE], -1, YEAR)

 

the second column does not give the value from last year, it returns the same value of current year

 

What am I doing wrong? Thanks!

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Phil_Seamark Super Contributor
Super Contributor

Re: DATEADD returns same value - cannot do YOY

What date field are you using in your visual? 

 

One from your 'sales_report' table? or the one from your 'DATE' table?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Dominaky Frequent Visitor
Frequent Visitor

Re: DATEADD returns same value - cannot do YOY

That was the problem! I was using the date field from the sales_report in my visual. Now it works!

 

Thank you.

2 REPLIES 2
Phil_Seamark Super Contributor
Super Contributor

Re: DATEADD returns same value - cannot do YOY

What date field are you using in your visual? 

 

One from your 'sales_report' table? or the one from your 'DATE' table?


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Highlighted
Dominaky Frequent Visitor
Frequent Visitor

Re: DATEADD returns same value - cannot do YOY

That was the problem! I was using the date field from the sales_report in my visual. Now it works!

 

Thank you.

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.

Top Kudoed Authors
Users Online
Currently online: 339 members 3,484 guests
Please welcome our newest community members: