Transform Data in Power Query

[Anonymous]

I have two tables one has entries for dimensions with a dimension set id.

My other table has ledger entries that I am trying to create a realtionship between these two tables so I can show all the transactions associated with a specfic dimension codes. What would be the best way to create one line for each Dimension set id so that I can create a relationship?

[mussaenda]

Hi @Anonymous ,

Your first table has two lines for each SET ID and you only want one line to be able to create a relationship to your second table.

Am I getting you right?

On your first table you can use the pivot column function.

Hope this helps!

[Icey]

Hi @Anonymous ,

What do you mean that "...create one line for each Dimension set id..."?

For creating relationships, please refer to this document: Create and manage relationships in Power BI Desktop.

Best regards

Icey

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

[edhans]

I'm not sure I understand your issue. Your first table seems to have a unique Dimesion Set ID and your second table has repeated Dimension Set IDs. That is the text-book definition of a valid One-To-Many releationship in Power BI.

Can you explan exactly what it is you are trying to accomplish? And if you need any transformations, please provide some usable data. Images are good for end goals, but not for data.

How to get good help fast. Help us help you.
How to Get Your Question Answered Quickly
How to provide sample data in the Power BI Forum