DAX formula, using randbetween, returns same values

[ilcaa72]

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

[Anonymous]

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 ), "-#" )
)