cancel
Showing results for
Did you mean:
Highlighted
Regular Visitor

## difference in average revenue between different periods of the same holiday

I don't know how to calculate the 2 columns in red. Since it is not possible to use date dimensions, which dax structure should I use to calculate the percentage difference between these values ​​for the same holiday period that occur at different times of the year?

 Holida Average Revenue Last Average Revenue Diff % 2018 100 30/03 150 31/03 50 2019 200 100 50% 10/04 300 150 11/04 100 50 2020 150 200 -33% 27/04 200 300 28/04 100 100

Help me plz. THX!

2 REPLIES 2
Highlighted
Super User IX

## Re: difference in average revenue between different periods of the same holiday

That being said, See if my Time Intelligence the Hard Way provides a way of accomplishing what you are going for.

https://community.powerbi.com/t5/Quick-Measures-Gallery/Time-Intelligence-quot-The-Hard-Way-quot-TIT...

---------------------------------------

Putting square pegs in round holes since 1972.

##### I have a NEW book! DAX Cookbook from Packt
Over 120 DAX Recipes!

Proud to be a Super User!

Highlighted
Regular Visitor

## Re: difference in average revenue between different periods of the same holiday

Original Table:

I have a table with dates from 2017 to 2021 and a column with the revenue per day. I have another column with the holidays, which normally last 3 days, however from year to year there are same holidays that fall on different days. I made an averagex to calculate the average revenue per holiday. Now I would like to calculate a percentage difference measure of the average revenue per holiday period over the years, as in the table in the original question.

I want to assemble on the power bi a segmenter with the name of the holidays and a matrix with the years, the average revenue considering only the selected holidays and the percentage difference compared to the previous holiday (which probably does not fall in the same period of the previous year) .

Segmenter:

Matrix:

 Year Avarege Revenue Diff % 2017 100 2018 200 50% 2019 150 -33%

is very similar to calculating the percentage difference from the previous year, however the days compared are different from year to year, what we have in common is the holiday column

Help plz =D

Announcements

#### Meet the 2020 Season 2 Power BI Super Users!

Find out who's part of the program this season, and welcome the new Super Users.

#### August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

#### July 2020 Community Highlights

Learn about the exciting things that happened in July.

#### Featured Data Story of The Month

All Data Stories Gallery contributions are reviewed for each month. We select a contribution and feature the community member the following month.

#### Power BI Dev Camp - Developing with .NET Core

Learn how to develop custom web applications for Power BI using .NET Core 3.1 and .NET 5.

Top Solution Authors
Top Kudoed Authors