cancel
Showing results for 
Search instead for 
Did you mean: 

Excel to DAX Translation

OK, I've been thinking about this for a while now. I've recreated a number of Excel functions over the years in DAX. And people in the forums are constantly asking questions about how to perform a certain Excel calculation in DAX. So, I figured, why not create some kind of translation table? Except, it's a lot of work. So, I'm going to post this initial list and I am hoping that others within the community can help out by posting comments to this post regarding DAX solutions for Excel functions. You help post solutions in comments, I'll edit this article series and add in the solution to the table with appropriate credit given. How does that sound? Could be fun! 🙂

 

Due to size restrictions for posts, I had to break this up into many, many articles:

Article Functions

DAX Equivalent

Functions

Total DAX

Solutions

N/A % Complete
Excel Functions A - B 47 16 35 5 85%
Excel Functions C - CL 16 11 11 3 88%
Excel Functions CO - CU 43 14 31 10 95%
Excel Functions D - E 48 13 44 4 100%
Excel Functions F - G 43 12 30 3 77%
Excel Functions H 9 2 8 1 100%

Excel Functions I-IM

29

3

28

1

100%

Excel Functions IN-K

25

12

16

7

92%

Excel Functions L - M 38 17 33 1 89%
Excel Functions N - O 30 14 24 2 87%
Excel Functions P - Q 29 12 22 1 79%
Excel Functions R 22 13 19 3 100%
Excel Functions S 40 17 35 5 100%
Excel Functions T - U 31 20 27 1 90%
Excel Functions V - Z 28 14 23 2 89%
Comments

This is awesome Thank you for putting this together. I am pretty confident in Excel but just started using Power Bi in the last week and have been looking for the Rosetta stone.