In my recent quest to create or catalog as many DAX equivalents for Excel functions, here are four measures dealing with logs and exponentials.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Thanks @v-qiuyu-msft It's been an effort, 43 new quick measures since I started this exercise, starting to think this may have been a bad idea! 🙂
But, actually, learning a lot and coming up with some new patterns. Well, new to me at least! 🙂
Probably the trickiest thus far was TRIMMEAN but my favorite is IMSQRT just because it makes me laugh every time I say it or look at the image I posted it with.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
But, actually, learning a lot and coming up with some new patterns. Well, new to me at least! 🙂
Probably the trickiest thus far was TRIMMEAN but my favorite is IMSQRT just because it makes me laugh every time I say it or look at the image I posted it with.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
Helpful resources
Power BI Monthly Update - September 2025
Check out the September 2025 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
