General Ledger with dimensionsets

[GrahamR99]

Hello

I am querying Microsoft Dynamics Business Central.

I have two tables;

General Ledger enteries.

GL Dimensionsets

The General Ledger enteries has a column called DimensionsetID, this links to GL Dimensionsets.

However GL Dimensionsets has mulitple enteries for 1 ID.

So it's like;

DimensionsetID,Dimension_Code,Dimension_Code_Value

8,Cost_centre,30-33-001

8,Source,Merlin

8,Period,5

8,Year,2021

I want to add these demsions to my General Ledger enteries table.

How do I do that in Power BI?

So I will have all the General Ledger enteries columns, then columns Cost_centre,Source,Period,Year.

30-33-001,Merlin,5,2021

I have tried doing a Merge but that gives me 4 rows a line for each column, I just want one row of data.

Regards

Graham

[DataInsights · Accepted solution]

@GrahamR99,

Try this in Power Query.

1. Select column Dimension_Code and click "Pivot Column":

2. Select values:

3. Result: