Merge Queries Without Repeating the Values

[third_hicana]

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.

[Anonymous]

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.

[lbendlin]

data model and merging columns

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

[third_hicana]

@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]

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

[third_hicana]

@lbendlin 
The criteria is the BOP + Suffix IDs are under one BOP ID which has a budget below.
The 1,038,010 capex and 191,800 opex 

[lbendlin]

If yes then add that filter to your measure.