Forum Discussion

Dominaky's avatar
Dominaky
Frequent Visitor
8 years ago
Solved

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'...
  • Phil_Seamark's avatar
    8 years ago

    What date field are you using in your visual? 

     

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

  • Dominaky's avatar
    Dominaky
    8 years ago

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

     

    Thank you.