Equivalent to EXP function (from Excel) in Power BI

augustindelaf — Thu, 14 Nov 2019 16:48:00 GMT

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]).

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

topic Equivalent to EXP function (from Excel) in Power BI in Developer