Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

dynamic dimensions

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 ...
Need Help
Show and Tell
  • v-danhe-msft's avatar
    v-danhe-msft
    7 years ago

    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

v-danhe-msft's avatar
v-danhe-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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