Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey,
I found this link to create dynamic dimensions and this is exactly what i need:
http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi
In the link as you see further, there is a part that looks as follows:
I would like to understand how the Document and Dimension column came from the "Dimension" and "Purchase" Table
Solved! Go to Solution.
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @Anonymous,
Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?
Regards,
Daniel He
Hi @Anonymous,
Based on my test, you could crossjoin the different columns in the query editor:
Create a blank query and add code in advanced editor:
let Source = Table1[A] in Source
Convert the list to table and add customer column:
Apply it and you could create the relatinships.
You could also download the pbix file to have a view.
Regards,
Daniel He
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |