Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
8 years ago

DAX formula, using randbetween, returns same values

 

sales = 

var addproduct = 
    ADDCOLUMNS(
        numbers,
        "product",
        var make =
            RANDBETWEEN(65,90)
        var mymodel =
            FORMAT(RANDBETWEEN(1,5), "-#" )
        return
            REPT( UNICHAR(make), 3) & mymodel
)
return addproduct

this formula is returning the same numbers and values, i cant see the error in formula.. thanks

 

DDD-1

DDD-1

DDD-1

DDD-1

DDD-1

DDD-1

DDD-1

DDD-1

etc

etc

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Creating a variable will perform the calculation ONCE, and then use that same value over and over.  You want to have a different calculation for each row of the numbers table.  Try this instead:

     

    sales =
ADDCOLUMNS (
    numbers,
    "product", REPT ( UNICHAR ( RANDBETWEEN ( 65, 90 ) ), 3 )
        & FORMAT ( RANDBETWEEN ( 1, 5 ), "-#" )
)