Hi Team,
Looking to understand how others would tackle the following task...
Here's a very simple example of my data set:
<tbody>
</tbody>
On occasions, a user will want to compare two different versions - e.g. 'A' and 'C' - to see where movement has occurred.
The challenge:
I'm sure DAX measures could be used for this, but I'm wondering if there is a way of doing it in Power Query, perhaps more efficiently?
Thanks in advance to any potential helpers!
Cheers,
Matty
Looking to understand how others would tackle the following task...
Here's a very simple example of my data set:
Version | Month | Forecast |
---|---|---|
A | Jan | 10 |
A | Feb | 3 |
A | Mar | 8 |
A | Apr | 5 |
A | May | 3 |
A | Jun | 7 |
A | Jul | 8 |
A | Aug | 1 |
A | Sep | 10 |
A | Oct | 9 |
A | Nov | 3 |
A | Dec | 4 |
B | Jan | 4 |
B | Feb | 5 |
B | Mar | 8 |
B | Apr | 2 |
B | May | 4 |
B | Jun | 10 |
B | Jul | 4 |
B | Aug | 6 |
B | Sep | 6 |
B | Oct | 2 |
B | Nov | 10 |
B | Dec | 5 |
C | Jan | 2 |
C | Feb | 8 |
C | Mar | 1 |
C | Apr | 8 |
C | May | 5 |
C | Jun | 7 |
C | Jul | 2 |
C | Aug | 5 |
C | Sep | 4 |
C | Oct | 1 |
C | Nov | 2 |
C | Dec | 2 |
<tbody>
</tbody>
On occasions, a user will want to compare two different versions - e.g. 'A' and 'C' - to see where movement has occurred.
The challenge:
- Establish a way of showing the versions that are available so that the user can choose which two to compare;
- Create a table containing both of the versions chosen as well as the delta (difference) between the two;
- Pass the resulting data set back for analysis.
I'm sure DAX measures could be used for this, but I'm wondering if there is a way of doing it in Power Query, perhaps more efficiently?
Thanks in advance to any potential helpers!
Cheers,
Matty