Forum Discussion

Shamatix's avatar
Shamatix
Post Partisan
8 years ago

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.

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

  • McCow's avatar
    McCow
    Resolver III

    Hi all!

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

    or so:

     

     

     

     

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

    Best regs!

    • McCow's avatar
      McCow
      Resolver III

      Hi!

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

      best regards!

      • tsagarrao's avatar
        tsagarrao
        Regular Visitor

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    definitely interested in a solution too

    • Shamatix's avatar
      Shamatix
      Post Partisan

      Anonymous wrote:

      definitely interested in a solution too


      Seems like no one knows how tho =/