Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am trying to figure out how to calculate the percent change in expense quarter to quarter for a data set similar to the one below
Firm | Quarter | Expense |
Firm A | 2017 Q3 | 100 |
Firm A | 2017 Q4 | 200 |
Firm A | 2018 Q1 | 300 |
Firm B | 2017 Q3 | 50 |
Firm B | 2017 Q2 | 150 |
Firm B | 2018 Q1 | 200 |
Basically now that Q1 is over, I would want to know the percent change by firm from Q4 to Q1. I have wracked my brain and haven't come up with any good solutions. I have a calendar table set up, but am having a hard time dynamically calling on the previous 2 quarters.
Any ideas would be appreciated!
Solved! Go to Solution.
@doubles Is this the result that you are expecting ?
If it is different than this, please share your data and your expected output. You can download my power bi file
Hope it helps
@doubles Is this the result that you are expecting ?
If it is different than this, please share your data and your expected output. You can download my power bi file
Hope it helps
@ChandeepChhabra, this is exactly what i was trying to do. Thank you both for your responses -- both were helpful!
See if you can adapt my Sequetial Quick Measure here:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231
It was designed to make these kinds of calculations easier.
User | Count |
---|---|
103 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |