Forum Discussion

al3xw3il's avatar
al3xw3il
Frequent Visitor
8 years ago
Solved

How to create tables from multiple parameters?

Hi all,   I would like a table with two columns (i.e. Grind, Angle) using the Parameters below   StartGrind = 0 EndGrind = 200 GrindIncrement = 1 StartAngle = 0 EndAngle = 360 AngleIncrement...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Hi al3xw3il

     

    The answer I was suggesting was a DAX based solution, so you would do it in Power BI Desktop (not the query editor),

     

    Just click the highlighted "New Table" button on the modelling tab and paste in that code.

     

     

     

Phil_Seamark's avatar
Phil_Seamark
Microsoft Employee
8 years ago

Hi al3xw3il

 

Please try the following as a new calculated table :

 

New Table = CROSSJOIN(
    SELECTCOLUMNS(GENERATESERIES(0,200, 1),"Grind",[Value]) ,
    SELECTCOLUMNS(GENERATESERIES(0,360,10),"Angle",[Value])
    )
al3xw3il's avatar
al3xw3il
Frequent Visitor
8 years ago

Hi Phil,

 

Thanks for your reply.

 

But do you mean this? Apologies, I am not very good with Power BI...

 

let
New Table = CROSSJOIN(
SELECTCOLUMNS(GENERATESERIES(0,200, 1),"Grind",[Value]) ,
SELECTCOLUMNS(GENERATESERIES(0,360,10),"Angle",[Value])
)
in
New Table

 

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi al3xw3il

     

    The answer I was suggesting was a DAX based solution, so you would do it in Power BI Desktop (not the query editor),

     

    Just click the highlighted "New Table" button on the modelling tab and paste in that code.

     

     

     

    • al3xw3il's avatar
      al3xw3il
      Frequent Visitor
      8 years ago

      Thank you very much for your help Phil!

       

      It works wonder!