Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Hi!
Is my solution and description ok or you need some clarification?
best regards!
@McCow could you please share the sample pbix file ? The above link is not working for me.
definitely interested in a solution too
@Anonymous wrote:definitely interested in a solution too
Seems like no one knows how tho =/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |