Forum Discussion
Solved
Compare two sets of data
Hi; I'm fairly new to Power BI, so in addition to solving my exact question I wouldn't mind being pointed to examples of similar problems. What I would like to do is be able to compare select ...
I created my own solution of creating a "reference" table that is identical to the first. I can then build filters on either table and create measures to compare them.
Greg_Deckler
Community Champion
Community ChampionSample output is great, but sample input data as well would be even better. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
This is a sample of input data. I highlight the data the slicers for my output example pull from.
| Month | Units | Revenue | Profit | Product | Region | |
| Joe | Jan | 10 | 20 | 6 | Jeans | North |
| Joe | Jan | 10 | 20 | 6 | Jeans | South |
| Joe | Jan | 12 | 24 | 8 | Shirts | North |
| Joe | Jan | 12 | 24 | 8 | Shirts | South |
| Joe | Sep | 12 | 24 | 8 | Jeans | North |
| Joe | Sep | 12 | 24 | 8 | Jeans | South |
| Joe | Sep | 12 | 24 | 8 | Shirts | North |
| Joe | Sep | 12 | 24 | 8 | Shirts | South |
| Sam | Jan | 10 | 20 | 6 | Jeans | North |
| Sam | Jan | 10 | 20 | 6 | Jeans | South |
| Sam | Jan | 12 | 24 | 8 | Shirts | North |
| Sam | Jan | 12 | 24 | 8 | Shirts | South |
| Sam | Sep | 15 | 15 | 6 | Shirts | North |
| Sam | Sep | 15 | 15 | 6 | Shirts | South |
| Sam | Sep | 12 | 24 | 8 | Jeans | North |
| Sam | Sep | 12 | 24 | 8 | Jeans | South |