Getting ready

To prepare for this recipe, do the following:

  1. Open Power BI Desktop.
  2. Create a table called R01_Table using the following formula:
R01_Table = 
SELECTCOLUMNS(
ADDCOLUMNS(
GENERATESERIES(1,20,1),
"Number",
RANDBETWEEN(1,5)
),
"Value",[Number]
)