cancel
Showing results for 
Search instead for 
Did you mean: 
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
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

Thank you 2022 Review

2022 Monthly Feature Releases

We had a great 2022 with a ton of feature releases to help you drive a data culture.

Top Solution Authors
Top Kudoed Authors