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,
Base on my data I have Sales, Market share and need to calculate for Target. There are 2 conditions of Target.
1. If Market share=< 15%, Target = Sales + 10%
2. If Market share> 15%, Target = Sales + 15%
How can I create DAX for Target?
Thank you
Solved! Go to Solution.
@Busno , Try like
Switch( true(),
[Market share] <.15, [Sales]*1.1,
[Sales]*1.15
)
I got the solution
thank you all
Hey @Busno ,
please describe how you define Market Share.
I'm also wondering how periodically data refreshes have to be considered, as growing data might impact the Sales and therefor Marketshare.
Maybe you want to consider creating a pbix file that contains sample data, but still reflects your data model. Upload the pbix to onedrive or dropbox and share the link. If you are using Excel to create the sample data share the xlsx as well.
Regards,
Tom
@Busno , Try like
Switch( true(),
[Market share] <.15, [Sales]*1.1,
[Sales]*1.15
)
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 |
---|---|
110 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |