cancel
Showing results for
Did you mean:
Helper III

## Exponent calculation

Hi all,

I have a column decimal with varying powers say 0,10,18,28 etc. Another column amount, which contains different values. My task is to create a new column which does the following function,

```New column = if decimal <> 0 then (0.05*amount)/10^decimal
else (0.05*amount)/10```

I can't figure out how to do this. Creating a measure with exp option provides a feature to use an exponential function with a specific number only. I would like to generate exponential value for a column and perform the above operation.

Can somebody help me in pointing out in the right direction?

Thanks,

Indhu.

1 ACCEPTED SOLUTION
Community Support

Hi @indhu,

In power query, we can add a custom column using the formula as below.

`Custom = if [decimal]<>0 then 0.05*[amount]/Number.Power(10,[decimal]) else 0.05*[amount]/10`

Here is the result as we excepted.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/srngkyf65xim33h/Exponent%20calculation2.pbix?dl=0

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
4 REPLIES 4
Frequent Visitor

anyone worked with exponent calculation using calculated columns orr measures?

Community Support

Hi @indhu,

I entered a table as you descried and create a new column as below to meet your requirement.

`Column = IF(Table1[decimal]<>0 , (0.05*Table1[amount])/10^Table1[decimal],0.05*Table1[amount]/10)`

For more details, please check the pbix as attached.

https://www.dropbox.com/s/384kq8rkcccaple/Exponent%20calculation.pbix?dl=0

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.
Helper III

Thanks frank.

This is a calculated column, right? Is there any way to generate the same result in a custom column?

Thanks,

Kanthi.

Community Support

Hi @indhu,

In power query, we can add a custom column using the formula as below.

`Custom = if [decimal]<>0 then 0.05*[amount]/Number.Power(10,[decimal]) else 0.05*[amount]/10`

Here is the result as we excepted.

For more details, please check the pbix as attached.

https://www.dropbox.com/s/srngkyf65xim33h/Exponent%20calculation2.pbix?dl=0

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Announcements