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.
Hi there,
I have a matrix that shows breakdown of events and countries that looks something like this:
Country | Event 10803 | Event 14333 |
Italy | 6 | 8 |
UK | 43 | 32 |
US | 51 | 54 |
I want to add a column to the end of this that calculates the growth rate between these events, however, the way this report works is that a slicer will be used to select which events are displayed, so the measure cannot just be "Event 10803" - "Event 14333" because there are tons of event combinations that could be selected. What's more I want the growth rate to be based on event timing (this field is on the same object as the events), so the most recent event always gets placed as the first number. I calculated a similar measure (taking into account dynamically selected events, event date and revenue) by using the following code:
Event Revenue Growth = VAR SelectedCampaigns = VALUES ( Event[Start Date] ) VAR OldEvent = CALCULATE ( [Event Revenue (£)], FIRSTDATE( SelectedCampaigns ) ) VAR RecentEvent = CALCULATE ( [Event Revenue (£)], LASTDATE( SelectedCampaigns ) ) VAR Difference = RecentEvent - OldEvent RETURN DIVIDE ( Difference, OldEvent, 0)
This only works as a card however, as when I drag it into a table it shows 0% (because firstdate and lastdate pull out the same event when applied to a table with event as a column/row). Not sure if this code will help as it's a slightly different scenario but I thought it may prompt some ideas.
Any help would be great - thanks
Is that the source data? Example source data would be helpful. 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
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 |
---|---|
44 | |
25 | |
19 | |
16 | |
8 |
User | Count |
---|---|
70 | |
49 | |
45 | |
20 | |
16 |