Helpful DAX resource

Do you know the common DAX functions can be easily learned in Power BI?

DAX is simple to learn at a basic level, but advanced DAX skills require a deep understanding of storage & calculation, data engines, table & filter functions, relationships, iterators, etc., hence we need helpful resources.

Let’s see the four helpful DAX resources which I recently came across and thought to bookmark here.

DAX resource 1: Microsoft DAX

Official Microsoft DAXs reference guide has tons of valuable information about DAX. They dig into the different DAX’s, functions, some statements, proper syntax, operators, queries.

There’s a whole bunch of resources that are available.

https://docs.microsoft.com/en-us/power-bi/

DAX resource 2: DAX Formatter

It’s a great tool. It allows you to copy and paste your DAX code into a UI hit format and format your code for you. This tool is provided by SQLBI.com

It’s great because it comes with some options where you can customize the code based on your regional settings or your personal preferences, meaning if you like, short lines or long lines.

https://www.daxformatter.com/

DAX resource 3: DAX Guide

Next is the DAX guide. You can find it as mentioned below. You name the DAX function, they have got it.

They do a lot of great things on this site and they really dig into a lot of the context around which functions can be used with other functions, the different parts of functions that may be degraded and shouldn’t be used anymore.

They really provide a lot of detail and examples for the functions.

https://dax.guide/

DAX resource 4: DAX Studio

DAX Studio is an open-source tool that allows you to write, execute and analyze DAX queries, as well as troubleshoot and optimize your code.

DAX Studio is a client tool for executing DAX queries against various data sources including:

• PowerPivot in Excel
• Power BI Desktop / SSDT Integrated Workspaces
• Analysis Services Tabular
• Azure Analysis Services

DAX Studio will scan the local machine for any running instances of Power BI Desktop or SSDT Integrated Workspaces

https://daxstudio.org/

That’s the four important helpful resources for DAX.

Hope you found the post informative. Your valuable feedback, question, or comments about this post are always welcome by leaving me a message on contact form is truly appreciated.