Excel to DAX Translation

[Greg_Deckler]

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	20	38	5	91%
Excel Functions C - CL	16	11	11	3	88%
Excel Functions CO - CU	43	22	33	10	100%
Excel Functions D	33	11	21	1	100%
Excel Functions E	15	8	12	3	100%
Excel Functions F - G	43	13	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	15	18	7	100%
Excel Functions L - M	38	18	33	1	89%
Excel Functions N - O	30	20	28	2	100%
Excel Functions P - Q	29	18	26	1	93%
Excel Functions R	22	16	19	3	100%
Excel Functions S	40	19	35	5	100%
Excel Functions T - U	31	23	27	1	90%
Excel Functions V - Z	28	18	26	2	100%

[zetzler]

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.

[cabc_xlorla]

Hi Greg, this is fascinating, thanks a lot.

I see you don´t have an equivalent for the function: Trend.

Could this help ?
https://community.powerbi.com/t5/Desktop/DAX-to-create-a-Trend-line/m-p/400663#M183065

It helped me for plotting linear trends on this cycle plot: http://bitly.com/cycle_plots