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 defi...
Need Help
Show and Tell
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.

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    3 years ago

    pls provide some sample data of two tables.

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi,

      Sorry but it seems that I cant attach an excel or zip file on here so, I can only give a screenshot of the sample data. Please see below images.