cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Shamatix Member
Member

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

5 REPLIES 5
elfersi Regular Visitor
Regular Visitor

Re: Dynamic Column names based on Dimension

definitely interested in a solution too

Shamatix Member
Member

Re: Dynamic Column names based on Dimension


@elfersi wrote:

definitely interested in a solution too


Seems like no one knows how tho =/

McCow Member
Member

Re: Dynamic Column names based on Dimension

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!

McCow Member
Member

Re: Dynamic Column names based on Dimension

Hi!

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

best regards!

tsagarrao Frequent Visitor
Frequent Visitor

Re: Dynamic Column names based on Dimension

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