Forum Discussion
Exponent calculation
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
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
Hi v-frfei-msft,
Thanks frank.
This is a calculated column, right? Is there any way to generate the same result in a custom column?
Thanks,
Kanthi.
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