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 

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

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