To prepare for this recipe, do the following:
- Open Power BI Desktop.
- Use an Enter Data query to create a table called R06_Table that contains the following data:
Col A |
Col B |
Value |
A |
a |
5 |
A |
b |
6 |
B |
a |
-4 |
B |
b |
3 |
C |
a |
-9 |
C |
b |
0 |
C |
c |
14 |
D |
d |
5 |
E |
e |
5 |
F |
f |
5 |
G |
g |
5 |
H |
h |
5 |
I |
i |
5 |
J |
j |
5 |
K |
k |
5 |
L |
l |
5 |