Forum Discussion

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
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

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