Forum Discussion

lsouza's avatar
lsouza
New Member
6 years ago

Filter problem with 2 related sources

Hi,   I´m trying to connect 2 sources of data that are relatate with the "Cost Componet" columm, one has the budget information and the other have the execution of this budget.   Theses 2 sources...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi, lsouza 

 

Could you please show us some sample data and expected result with OneDrive for Business? Do mask sensitive data before uploading. Thanks.

 

Best Regards

Allan

lsouza's avatar
lsouza
New Member
6 years ago

Hi Allan,

 

I can only share link with my personal account. I've created just an excel with the data, you can find it here: https://1drv.ms/x/s!AqBFe2M1sEk97WDuwkdcDSO9z5Qx?e=T8eeUV

I need to conect the 2 sheets by the "Cost Component" column and creat a Table Visual in Power BI comparing the values of every category of "Cost Componet" (Budget x Execution). But then I want to filter them by Date.

 

Thanks for the attention!

  • v-alq-msft's avatar
    v-alq-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi, lsouza 

     

    I'd like to suggest you click 'Edit Query', go to Query Editor, duplicate the query 'Budget', click 'Merge Queries', set as follows.

     

    Then you may expand 'Execution' to get the columns you want, rename the query and then 'Close and Apply'.

     

    You can create a date table and create two relationships with budget date and execution date as follows.

     

     

    Calendar = CALENDARAUTO()

     

     

     

    Finally you may use an active corresponding relationship and the date column from Calendar table to filter the result. 

    Best Regards

    Allan

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.