Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
68 | |
64 |
User | Count |
---|---|
210 | |
118 | |
116 | |
81 | |
74 |