Appendix B
Excel functions with DAX or Power Query equivalents
Excel functions and DAX equivalents
Excel functions with Power Query M equivalents
As an Excel pro, you probably have a fairly good handle on the calculation functions used in Excel. Today, you might need to dabble in the Data Analysis Expressions (DAX) formula language when creating a new measure in a pivot table or in the M function language when cleaning data with Power Query. This chapter will help you transfer your knowledge of Excel functions to either DAX or Power Query.
The first table is an alphabetical list of Excel functions and the equivalent DAX function. If the Excel function is not in Table B.1, then there is no direct DAX equivalent.
The second table is an alphabetical ...
Get Microsoft Excel Inside Out (Office 2021 and Microsoft 365) now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
