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 a columm of date. I want to create a "Date filter" that applies for a table that compares the budget and the execution of this budget for every "Cost Component".

 

The table is:

Cost Componet | Budget | Execution (Where Cost Component is the link)

 

Can somebody help me?

Need Help

4 Replies

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