Creating visual for Period over Period changes.

[jwkuyper]

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"))
))

[vivran22 · Accepted 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