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 have a table with sales by agent and season like this:
agent | season | sales |
agent1 | AI18 | 12 |
agent2 | AI18 | 23 |
agent3 | AI18 | 32 |
agent1 | AI19 | 34 |
agent2 | AI19 | 23 |
agent4 | AI19 | 45 |
I try to obtain a power bi matrix as:
agent | AI18 | AI19 | delta |
agent1 | 12 | 34 | 22 |
agent2 | 23 | 23 | 0 |
agent3 | 32 | -32 | |
agent4 | 45 | 45 | |
Total | 67 | 102 | 35 |
Can i have an help, please?
Thanks
Duplicate the query,
Filter so that you only have one season in each query,
Merge the query on agent,
Finally create the delta.
Hope this helps!
sorry but,
i have a filter, where the user can choose the season and with a lookvalue function i find the last season.
So i writed two measure to calculate the quantity like this:
The problem is that in the "last season" colum, the value are present only when there is a value in a "quantity season" colum.
I like use the measure to obtain the goal, it's possible?
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |