Forum Discussion

jmstran87's avatar
jmstran87
Frequent Visitor
7 years ago

YOY Comparison

Hi,   I have seen several conversation surrounding this topic but I can't seem to find a solution that works for the data set I am working with. Although new to Power BI, the DAX experessions are e...
Need Help
jmstran87's avatar
jmstran87
Frequent Visitor
7 years ago

Anonymous 

Thanks for the feedback. I've created a dimdate table and tried to create a 'Revenue LY' measure. When I pull it into the workspace, I just get an error. 

 

 

Relationship below

 

Can you help  me understand what I'm doing wrong?

Anonymous's avatar
Anonymous
Not applicable
7 years ago

You are getting that warning because you are creating a relationship between month fields of both the table. Instead, I suggest you add a date field to your ecommerce table and create a relationship between the date fields instead of month fields.

 

 

  • jmstran87's avatar
    jmstran87
    Frequent Visitor
    7 years ago

    Anonymous 

     

    The reason that there is only a month field in my ecommerce table is because I only receive data on a monthly basis. Would creating a date field to still represent the month make a difference? I'll go ahead and try it out.

     

    - James

    • jmstran87's avatar
      jmstran87
      Frequent Visitor
      7 years ago

      Ok. That did not work. If someone can provide step by step what is needed to be done in order to generate YoY, given the tables I have, that would be great. I guess DAX isn't as easy as I thought. Note that data in the Ecom table is only provided at a Monthly level.

       

      DimDate Table

       

      Ecom Table

       

      • TeigeGao's avatar
        TeigeGao
        Solution Sage
        7 years ago

        Hi jmstran87 ,

        It would be pleasant if you can share the pbix file (with sample data) to us, we need to use it for test and analysis what has caused the problem.

        Best Regards,

        Teige