Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Merge two tables without missing any rows and without duplicating values from both tables

Hi All,   I have been searching and trying to findout a perfect solution for merging two tables without missing any data from both tables and without duplicating the values but i could'nt get anywh...
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    9 years ago

    Thanks for your valuable time to spent.

    I did every join to solve this, but i am unable to find out the exact solution that i need.

    But i did solved it by creating another table(MonthYear) which is having the month and date and Mon-Year columns.

    Then i created relationship among these three tables using Date column.

    And when i made a bar cart with plan and actual rev, It is showing the perfect values by keeping Mon-Year of MonthYear table in X-Axis.

     

    Thanks for spending your valuable time and giving suggestions.

     

    If you dont mine, can you please look in this issue please.

    https://community.powerbi.com/t5/Desktop/Need-Help-to-get-resolve-on-multiple-queries-of-Custom-KPI/m-p/175125#M76511

    I ll be so thankful to you.

    MohanV

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
9 years ago

Anonymous

 

Hi Mohan V,

 

Did you solve your problem? What else can I do for you?

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Thanks for your valuable time to spent.

I did every join to solve this, but i am unable to find out the exact solution that i need.

But i did solved it by creating another table(MonthYear) which is having the month and date and Mon-Year columns.

Then i created relationship among these three tables using Date column.

And when i made a bar cart with plan and actual rev, It is showing the perfect values by keeping Mon-Year of MonthYear table in X-Axis.

 

Thanks for spending your valuable time and giving suggestions.

 

If you dont mine, can you please look in this issue please.

https://community.powerbi.com/t5/Desktop/Need-Help-to-get-resolve-on-multiple-queries-of-Custom-KPI/m-p/175125#M76511

I ll be so thankful to you.

MohanV

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    9 years ago

    Anonymous

     

    Hi,

     

    It's my pleasure. I am so glad you have solved your problem. You can mark your answer as solution. It will be helpful to others. Since you asked, I will try my best to help in a proper way.

     

    Best Regards!

    Dale