Forum Discussion

Irwan's avatar
Irwan
Super User
2 years ago
Solved

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...
"Need Help"
  • Jack_D's avatar
    Jack_D
    2 years ago

    You can use following dax to creat a table 

    Hours = GENERATESERIES(1,15,1)
Jack_D's avatar
Jack_D
Frequent Visitor
2 years ago

You can use following dax to creat a table 

Hours = GENERATESERIES(1,15,1)
  • Irwan's avatar
    Irwan
    Super User
    2 years ago

    hello Jack_D ,

    that works wonderfully.

    Thanks and appreciate for the help.