Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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 ), "-#" ) )