Forum Discussion

augustindelaf's avatar
augustindelaf
Impactful Individual
6 years ago

Equivalent to EXP function (from Excel) in Power BI

Hello,

 

I am trying to reproduce in Power BI  some formulas that already exist in Excel (as Calculated Columns from the Modeling tab).

I successfully reproduced many of them but I am stuck on a "EXP" function.

 

Here's what I have in Excel : 

=EXP(EXP(([my column]-10,975)/14,534))-0,8

 

in Power BI, I have an error when I try the to use EXP function, for instance on column E2.       E2 = EXP[E 1]).what is wrong with my formula ?

Error : 

"An argument of function 'EXP' has the wrong data type or the result is too large or too small"

 

 

Why does it work in Excel and not in power bi ? It there something bad with data type of [E 1] column ?

Many thanks in advance !

Augustin

 

 

 

No RepliesBe the first to reply