Reply
Member
Posts: 135
Registered: ‎05-11-2017

Dynamic Column names based on Dimension

Hey fellow users of Power Bi,


I currently have 2 tables

A dimension table (Table 1)

An Item table (Table2)

 

In table 2 there is 4 columns named "Dim1" "Dim2" "Dim3" and "Dim4", in Table2 there is a translation for these 4 columns.

PBIDesktop_2018-06-28_10-07-03.png

Each translation is different pr customer so I want to make these translation in a dynamic way, but I am unsure as of how.

How can I make some dax or something that has a dynamic column name based on the translation in Table1 ?

Further more I have uploaded some static example data (.pbix) so you can play around.

You can download the .pbix file here: http://ge.tt/5u8grLq2


I hope someone can help me out.


Best regards

Regular Visitor
Posts: 27
Registered: ‎02-02-2017

Re: Dynamic Column names based on Dimension

definitely interested in a solution too

Highlighted
Member
Posts: 135
Registered: ‎05-11-2017

Re: Dynamic Column names based on Dimension


@elfersi wrote:

definitely interested in a solution too


Seems like no one knows how tho =/

Member
Posts: 88
Registered: ‎12-08-2017

Re: Dynamic Column names based on Dimension

[ Edited ]

Hi all!

I can't exactly understand you problem, it's worked as you described, like so:
DynColChanges.png

or so:DynColChanges2.png

 

 

 

 

And, eventually the link on yours example don't work at me Smiley Sad
The SAMPLE and LINK

Best regs!

Member
Posts: 88
Registered: ‎12-08-2017

Re: Dynamic Column names based on Dimension

Hi!

Is my solution and description ok or you need some clarification?

best regards!

Frequent Visitor
Posts: 2
Registered: ‎10-22-2018

Re: Dynamic Column names based on Dimension

[ Edited ]

@McCow could you please share the sample pbix file ? The above link is not working for me.