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
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

      • jmstran87's avatar
        jmstran87
        Frequent Visitor
        7 years ago

        TeigeGao 

        This is gonna sound absurd but how do I inlclude the pbix file? Can I not just drag and drop the file into the message window here? There isn't an attach file option either.