Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
jwkuyper
Frequent Visitor

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.

Capture.JPG

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 ACCEPTED SOLUTION
vivran22
Community Champion
Community Champion

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

View solution in original post

1 REPLY 1
vivran22
Community Champion
Community Champion

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

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.