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