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!
Go to Solution.
What date field are you using in your visual?
One from your 'sales_report' table? or the one from your 'DATE' table?
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!
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.