Forum Discussion

third_hicana's avatar
third_hicana
Helper IV
2 years ago

Merge Queries Without Repeating the Values

Hi Everyone. Askig for help regarding my data model and merging columns

 

I have two tables with one-to many relationship. I want to avoid repeating the values of 'Value' in Table 1 when merging to Table 2 using the BOP as common column. Please see the esired result below.

 

Appreciate your help. Thank you.

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

6 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago
    data model and merging columns

    There's your answer. Don't merge.  Use the data model.

    • third_hicana's avatar
      third_hicana
      Helper IV
      2 years ago

      lbendlin  Thank you.

       

      How can I create a measure that the capex and opex 'baseline budget £' will only appear once in the table visual? 

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        What would be your criteria? MIN of BOP+Suffix ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi third_hicana ,

     

    If you are getting the results based on the Actual column compared to the budget column, then you can refer to the steps below.
    I have made some adjustments to the data as I am not sure about the exact logic.


    In power query editor, when you get the table below.

     


    You can create a conditional column.

     

    Subsequently delete the unwanted columns.

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

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