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,
It's maybe really basic but I can't get around it, this is my measure:
Sales% = DIVIDE(SUM(Sales2018[Investment]);SUM(Sales2017[Investment]))
In some of cases this will get value higher than 100% (like 116%) but I would like to this play this value as +16%, is there some way to do this?
Solved! Go to Solution.
Hi @KelvinMorel,
Based on my test, you could refer to below formula:
Sales% = "+"&(DIVIDE(SUM(Sales2018[Investment]),SUM(Sales2017[Investment]))-1)*100&"%"
Result:
You could also download the pbix file to have a view.
Regards,
Daniel he
Hi @KelvinMorel,
Based on my test, you could refer to below formula:
Sales% = "+"&(DIVIDE(SUM(Sales2018[Investment]),SUM(Sales2017[Investment]))-1)*100&"%"
Result:
You could also download the pbix file to have a view.
Regards,
Daniel he
Hei v-danhe-msft,
Thank you so much, you help me out. I needed to modify a little bit your measure as follow: if you see another way please share
Sales% = (DIVIDE(SUM(Sales2018[Investment]);SUM(Sales2017[Investment]))-1)
> To get numbers
Sales%Sign = IF([Sales%]>0;"+"&ROUND(([Sales%]*100);0)&"%";ROUND([Sales%]*100;0)&"%")
> To get the signs in front
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 |
---|---|
111 | |
97 | |
80 | |
69 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |