Forum Discussion

s15's avatar
s15
Helper III
9 years ago
Solved

Multiply a column with a fixed constant

I cannot seem to find a way to multiple a column with a constant. For example I have total sales. Now I need to set the target is 15%. The measure would loke like   Target Sales = XXX(financials...
Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    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

s15's avatar
s15
Helper III
9 years ago

vanessafvg

 

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)

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
9 years ago

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

  • s15's avatar
    s15
    Helper III
    9 years ago

    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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi s15,

     

    Yes, math is interesting. And Great to help!

     

    By the way, as the problem is resolved, could you accept the corresponding reply as solution to close this thread(which could also help others who may have similar issue easily find the answer)? :smileyhappy:

     

    Regards