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
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)
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).
s15 can i see how you created your measure? works fine on my side