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.
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.
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 |
---|---|
97 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |