Forum Discussion
Multiply a column with a fixed constant
Hi s15,
I just firgured out the way. Instead of 0.15, it must be dividing 100/15 because I cannot seem to find a MULTIPLY function in my case. Math is awesome init'?
Target Sales = SUM(financials[ Sales]) + DIVIDE(SUM(financials[ Sales]),100/15)
Yes, there is no MULTIPLY function in DAX. The arithmetic operator * (asterisk) is usually used for multiplication. So you should also be able to simply use the formula below to calculate the Target Sales in this scenario. :smileyhappy:
Target Sales = SUM(financials[ Sales]) * (1 + 0.15)
Regards
Hi vanessafvg
I need to create a measure which I want to multiply the current Sales with 15%. Saying my total sales revenue is 10,000 USD. But the target next year should be 11,500. However there is no such a column or value in my table. Do I have to create a new column to store the target sale value?
The reason I need the new measure is that I will use Gauge chart to display Sales revenue and my target sales. Right now the Sales revenue is SUM.
you will need to change the measure names back to yours
this needs to be a measure
sales target amount = sum(Sales[SalesAmount]) + DIVIDE(SUM(Sales[SalesAmount]),0.15)
I just firgured out the way. Instead of 0.15, it must be dividing 100/15 because I cannot seem to find a MULTIPLY function in my case. Math is awesome init'?
Target Sales = SUM(financials[ Sales]) + DIVIDE(SUM(financials[ Sales]),100/15)
Hi s15,
I just firgured out the way. Instead of 0.15, it must be dividing 100/15 because I cannot seem to find a MULTIPLY function in my case. Math is awesome init'?
Target Sales = SUM(financials[ Sales]) + DIVIDE(SUM(financials[ Sales]),100/15)
Yes, there is no MULTIPLY function in DAX. The arithmetic operator * (asterisk) is usually used for multiplication. So you should also be able to simply use the formula below to calculate the Target Sales in this scenario. :smileyhappy:
Target Sales = SUM(financials[ Sales]) * (1 + 0.15)
Regards
Thank you v-ljerr-msft . Math is interesting. Though Excel users love to put "15%" in the formula.
Thank you all v-ljerr-msft and vanessafvg
vanessafvg divide is not correct because the target sales is supposed to only increase 15%. It basically means that I need to top up 15% of the current sales revenue. I think measure name does not matter. It should be whatever I need right? The main thing is the caculation of multiplication.
s15 have you tested the measure i created?
i am getting 15% of total sales and adding it to the total sales is that not what you want?
vanessafvg I did but this looks incorrect.
The current sales is 118.73M. The target sales with 15% increase is 136.5395. With Excel, it's easy like this
While the measure you provided is to divide 118.73 into 0.15 (equally mutiply 6,6 times).