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.