Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Very difficult to be specific with the information provided. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
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...
Original Table:
Date | Holiday | Revenue |
01/03/2018 | 100 | |
02/03/2018 | finados | 50 |
03/03/2018 | finados | 80 |
04/03/2018 | finados | 70 |
05/03/2018 | 90 | |
06/03/2018 | 60 | |
... | ... | ... |
27/04/2019 | finados | 150 |
28/04/2019 | finados | 200 |
29/04/2019 | finados | 40 |
30/04/2019 | 30 |
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:
Feriados |
Natal |
Ano Novo |
Finados (Selected) |
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |