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

     

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi ryan_mayu ,

         

         

        I tried to do your sample, however I have a zero result.

        Actually, I am newbie in PowerBI and started using the application 3 days ago.

        All other reports were already done exept of the final result which is computation of Actual/Target.

        So here are the steps I did:
        1. Create a department table 

        Department = DISTINCT('Target Name'[Department])
         
        2. Create a Date Table
        Selection Date = CALENDAR(MIN('Target'[R72 Date]),MAX('Target'[R72 Date]))
         
        3. On the actual value table, I created the calculation column:
        Performance = sum('Actual Data'[Total Processed)/SUM('Target'[TargetValue])
         
        4. From the relationship connection, I linked "R72 Date" and "Actual Date" to step 2 date, and 'Target'[Department] and 'Actual Data'[Department] to step 1 department.

        5. Finally From a matrix table:
        Rows = (Created Department)
        Column = (Created Date)
        Values = (Performance Calculation)
         
        Is there any steps I missed?