Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Combining Totals from 2 different tables

Hi everyone,

 

I need a help regarding combining the results of 2 different source tables in Power BI. Please see below:

 

The first table is static, with manual input, where the dates defined always starts at first of the month(eg. 1/1/23, 2/1/23, etc) while in the second table, dates varies.
My end goal is to calculate the percentage achieve from the target to the actual live data.

I tried to merge the table data but their respective result changed.

I also tried to have a one way relationship between the common field of the table which is the department but still, does not displayed the correct values.

Also, either of the 2 values can have an additional department, which ever is updated first, it may be first table or the second table.

 

So my final approach is to have the 2 tables having separate visuals but have a third table with their combined result. But I cant figure out how to achieve this.

 

Can anyone help me with this? A step by step guide would be much appreciated.

Thank you in advance.

 

 

Best regards,

Ray

Need Help
Show and Tell

11 Replies

  • Migasuke's avatar
    Migasuke
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi Anonymous ,

    You refer to Dates but in your tables you have no dates column. Are those two example tables completely same as your data source?

    Thanks.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

       

      Thank you for your response.

      The table have a date column. It is the Qtr 1, Qtr2, etc. You can expand/drill those columns to display by months. As I mentioned, the dates are in this format: (eg. 1/1/23, 2/1/23, etc)

      Qtr 1  Qtr 2  
      January  February  March  April  May  June

       

      They are not in same data source. The Target table is a user defined table, while the Actual table comes from another live source though they reside on same database.

       

       

      Thanks.