Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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
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
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |