To prepare for this recipe, do the following:
- Open Power BI Desktop.
- 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 |