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 folks, newbie so pls go easy, still finding my feet.
I have a data table which contains product sales. I have created measures to consider year-on-year change in sales performance and against 3-year average. The one thing I'm struggling to do is show how each product is performing against target. On 1 product I have to increase sales by 3% against the 3-yr ave but with another it's 10%. Some products I've only to improve sales versus previous year. Can I create 1 measure that uses different % change targets or do I need to do this in my source data? Hope that makes sense.
Solved! Go to Solution.
Many thanks for such a prompt response @speedramps . I have a seperate SQL view that has the product sales aggregated so I will do as you suggest using that approach. Very grateful for your time.
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 |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |