The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I currently have a measure that captures revenue by Quarter as shown below. I would like to create an additional column that would provide QoQ changes. I would eventually like to turn the QoQ changes into a line chart as well.
Is there a way I can do this? Let me know if additional detail is needed.
Also, please view my DAX code for reference.
Revenue =
CALCULATE(
sum('Essbase Periodic ALL FCST'[Value]),
FILTER(
'Essbase Periodic ALL FCST',
and(
'Essbase Periodic ALL FCST'[Filter_Direct Expenses Ex. Bonus Pool]="Revenue",
or(
'Essbase Periodic ALL FCST'[Actual/CurrentFCST?]="Actual",
'Essbase Periodic ALL FCST'[Actual/CurrentFCST?]="Current FCST"))
))
Solved! Go to Solution.
Hello @jwkuyper ,
Any date-time related calcualtions becomes easy when you have a dedicated calendar table defined in your data model. There are time intelligence DAX available, which enables you to calculate quaterly summary and QoQ variations.
You may refer to the following article on creating calendar using DAX:
https://www.vivran.in/post/power-bi-time-intelligence-calendar-table
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
Hello @jwkuyper ,
Any date-time related calcualtions becomes easy when you have a dedicated calendar table defined in your data model. There are time intelligence DAX available, which enables you to calculate quaterly summary and QoQ variations.
You may refer to the following article on creating calendar using DAX:
https://www.vivran.in/post/power-bi-time-intelligence-calendar-table
Cheers!
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
Connect on LinkedIn
User | Count |
---|---|
16 | |
8 | |
6 | |
6 | |
5 |
User | Count |
---|---|
23 | |
13 | |
13 | |
8 | |
8 |