Forum Discussion
Irwan
2 years agoSuper User
Automatically Generate Number as Row Value
Hello Power BI Expert, need an advice about DAX.
I am trying to create a new table with one column but with vary row value depends on one condition. Let's say the condition is 15 (or max hours in below case), so I am trying to make a new table with 15 rows contained value of 1-15 for each row.
My problem is, is there any way to create the same table without writing the number one-by-one?
Thank you and really appreciate for the help.
You can use following dax to creat a table
Hours = GENERATESERIES(1,15,1)