Forum Discussion

jwkuyper's avatar
jwkuyper
Frequent Visitor
6 years ago
Solved

Creating visual for Period over Period changes.

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

 

1 Reply