Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
augustindelaf
Impactful Individual
Impactful Individual

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 ?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

 

 

 

0 REPLIES 0

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.