Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

join two tables into one

Hi everyone. I have one question and I hope you can help me. I have two matric tables. First of them show information for Current fiscal year and second shows information for prior fiscal year.  ...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Tahreem24 , thanks for your helping, I just change my sql, and it's worked 

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
7 years ago

Hi Anonymous ,

 

You can join your current year and prior year table with the help of "Merge Queries" option in Query Editor based on you common column (for example: product name) and then create the variance column like normal calculated column.

 

I tried to replicate your question to some extent and see the expected result. See below steps in screen shot.

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Tahreem24

My two tables are in same query. Can you show implementation dax process?

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    7 years ago

    Please eleborate more so that I can help you.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      My date table is from another query and my product group, Current year and prior year are from another query. How can I merge them,
      It will be helpful if you show me steps via screenshots
      Thanks

       

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User
        7 years ago

        Sure,  but if you give me structure of table and sources of those table so I will probably help you.

        Actually as per your question I have replicated the scenario in my system and put current and prior year table in two different table then marged them into single table and found the variance.