QoQ comparison of last two years

[sanghamitra123]

Hi Everyone,

Need your help as i am new to Power Bi. I need to compare the QoQ for two years, lets say Q1 2017 Vs Q1 2018. so when i drill down this comparision, it should be Month 2017 Vs Month 2018 and further week 2017 Vs week 2018. Pls let me know how to do this. Appreciate an early reply, since its very urgent for me.

Thank you.

[v-piga-msft · Accepted solution]

Hi @sanghamitra123,

It seems that you want to compare the QoQ for two years.

Here is my sample. If you create two measures like below, then you could get the compare chart for QoQ for two years.

2017 Qtr = CALCULATE(SUM(Table1[Sales]),FILTER('Table1',YEAR('Table1'[Date])=YEAR(MIN('Table1'[Date]))))

2018 Qtr = CALCULATE(SUM(Table1[Sales]),FILTER('Table1',YEAR('Table1'[Date])=YEAR(MIN('Table1'[Date]))+1))

In addition, you could have a reference of this video for Quarter On Quarter Sales Trends In Power BI - DAX Formula.

If you still need help, please share some data sample and your desired output so that we could help further on it.

Best  Regards,

Cherry

[sanghamitra123]

Hi Cherry,

I managed to get the chart as below, thanks a lot. Pls let me know if there is a way to drill down further into months and weeks in the same chart, comparing two years (Same as we did for quarter) 

Regards

Sanghamitra

[sanghamitra123]

Hi Cherry,

The below graphs looks absolutely fine for me.

I tried this way, the problem here is i am n ot using any DB, i am using Excel. Is there a way we can write measures for excel too.