comparing data from first quarter in two years
Data Science Asked by Pardhu K on December 25, 2020
How can I compare data from two quarters? What software can I use to do it parallelly side by side so I can compare them. What kind of factors can I take into consideration, I’m posting a sample data set pic
One Answer
I am not sure what output you are looking for.
There are many ways to do it. You can do it by creating a measure in Power BI or in PowerPivot or just using Powerquery - below is an example.
PowerPivot and PowerQuery can both put the output into a pivot table in Excel if that's something you prefer.
Pick up city Q1 Q2
X Amount1 Amount 2
Y ... ...
Answered by Hao Xu on December 25, 2020
Add your own answers!
Ask a Question
Get help from others!
Recent Answers
- Jon Church on Why fry rice before boiling?
- Peter Machado on Why fry rice before boiling?
- Lex on Does Google Analytics track 404 page responses as valid page views?
- Joshua Engel on Why fry rice before boiling?
- haakon.io on Why fry rice before boiling?
Recent Questions
- How can I transform graph image into a tikzpicture LaTeX code?
- How Do I Get The Ifruit App Off Of Gta 5 / Grand Theft Auto 5
- Iv’e designed a space elevator using a series of lasers. do you know anybody i could submit the designs too that could manufacture the concept and put it to use
- Need help finding a book. Female OP protagonist, magic
- Why is the WWF pending games (“Your turn”) area replaced w/ a column of “Bonus & Reward”gift boxes?