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
firstl yare you creating a colum or a measure?
I am not quite sure what you trying to do, is a running total?
so you want to add 15% to the current sales (in a column not a measure?) ie by row and add that to the original amount?
s15 target sales = ((sumx(financials[sales]) * 15%) + sumx(financials))
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
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?