comparing data from first quarter in two years


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

enter image description here

Pardhu K

Posted 2019-04-24T05:15:55.950

Reputation: 11



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              ...       ...

Hao Xu

Posted 2019-04-24T05:15:55.950

Reputation: 1