To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R07_Table3x4 that contains the following data:
|
Column1 |
Column2 |
Column3 |
Column4 |
Index |
|
-4 |
1 |
4 |
-2 |
1 |
|
-3 |
-1 |
2 |
5 |
2 |
|
3 |
0 |
6 |
7 |
3 |
- Use an Enter Data query to create a second table called R07_Table4x2 that contains the following data:
|
Column1 |
Column2 |
Index |
|
8 |
1 |
1 |
|
9 |
10 |
2 |
|
11 |
3 |
3 |
|
-1 |
0 |
4 |