Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Dominaky
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
Phil_Seamark
Microsoft Employee
Microsoft Employee

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!

View solution in original post

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

 

Thank you.

View solution in original post

2 REPLIES 2
Phil_Seamark
Microsoft Employee
Microsoft Employee

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!

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
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.