Getting ready

To prepare for this recipe, do the following:

  1. Open Power BI Desktop.
  2. Use an Enter Data query to create a table called R01_Table with the following data:

ID

Value1

Value2

Value3

Value4

1

1

2

3

4

2

10

20

30

40

3

100

200

300

400

4

1000

2000

3000

4000

5

10

10

10

10

6

10

10

0

0

7

5

10

15

20

8

50

100

150

200

9

10

100

1000

10000

10

1

200

30

4000