cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AAbdelkader Regular Visitor
Regular Visitor

Dax or M Language

Hello there,

 

I need to ask which the effective language that should I deep dive into, which language is worthy to rely on my data analysis. I'm still a newbie in BI but I'm familiar with creating the desired report and chart based on a little knowledge of BI. And I need to start deep dive into data analysis through the provided BI language, but the question here Dax or M Language or both of t them? I'm relly messy.

 

thanks a lot.

3 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User
Super User

Re: Dax or M Language

You emphasized Data Analysis twice in your post so I'll say DAX first!

DAX stands for Data Analysis Expressions after all Smiley Happy

That said inevitably you WILL need some knowledge of M

However the User Interface in the Query Editor is extremely helpful so you can delay having to learn M indefinitely Smiley Wink

Don't let @ImkeF and @MarcelBeug see this post Smiley Very Happy

Super User
Super User

Re: Dax or M Language

Check out this article fresh from the press: http://radacad.com/m-or-dax-that-is-the-question

 

Agree with @Sean : Make use of the wonderful user interface in the query editor which let's you glide into the language with minimal efford, if you start to read the code that has been created with your interactions:

 

PBI_MorDAX.jpg

1) Make sure that the Formula Bar is visible (2)

3) Click on each stepname and see what code has been generated (2)

 

It's a bit like the Macro-recorder in Excel. It's a painless excercise at the beginning and you will develop a feeling for the syntax of the language and in no time you might start to twitch the code a bit and explore coding :-)

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Pfister Established Member
Established Member

Re: Dax or M Language

Hi AAbdelkader

 

I totally agree with @ImkeF and @Sean.

 

My advise to my team is simple:

- import and massage data by using Power Query aka M in Power BI.

- Create your calculation with DAX.

 

By learning Dax and M you will learn to find the nuances and intersections in the two languages.

 

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com
12 REPLIES 12
Highlighted
Super User
Super User

Re: Dax or M Language

You emphasized Data Analysis twice in your post so I'll say DAX first!

DAX stands for Data Analysis Expressions after all Smiley Happy

That said inevitably you WILL need some knowledge of M

However the User Interface in the Query Editor is extremely helpful so you can delay having to learn M indefinitely Smiley Wink

Don't let @ImkeF and @MarcelBeug see this post Smiley Very Happy

Super User
Super User

Re: Dax or M Language

Check out this article fresh from the press: http://radacad.com/m-or-dax-that-is-the-question

 

Agree with @Sean : Make use of the wonderful user interface in the query editor which let's you glide into the language with minimal efford, if you start to read the code that has been created with your interactions:

 

PBI_MorDAX.jpg

1) Make sure that the Formula Bar is visible (2)

3) Click on each stepname and see what code has been generated (2)

 

It's a bit like the Macro-recorder in Excel. It's a painless excercise at the beginning and you will develop a feeling for the syntax of the language and in no time you might start to twitch the code a bit and explore coding :-)

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Imke Feldmann

How to integrate M-code into your solution -- Check out more PBI- learning resources here -- Performance Tipps for M-queries




Pfister Established Member
Established Member

Re: Dax or M Language

Hi AAbdelkader

 

I totally agree with @ImkeF and @Sean.

 

My advise to my team is simple:

- import and massage data by using Power Query aka M in Power BI.

- Create your calculation with DAX.

 

By learning Dax and M you will learn to find the nuances and intersections in the two languages.

 

Greetings Hp Pfister
Power Query Buch online auf http://www.powerbi-pro.com
Phil_Seamark Super Contributor
Super Contributor

Re: Dax or M Language

Learn both. Smiley Happy


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Super User
Super User

Re: Dax or M Language

Not much to add from my side.

The general rules when to use M or DAX are clearly explained, but in my opinion there are still grey areas where both M and DAX can be used.

 

 

Specializing in Power Query Formula Language (M)
jmdh Member
Member

Re: Dax or M Language

If i may add something: i think PowerBI has done a great job at hiding the intricacies of M for the beginner, but has still a lot to improve to do the same for DaX  with mux more power in the UI and better Table and Matrix Visuals, plus imrpoved exports.
This is especially important since many of these new users will come with their user experience and frankly, sometimes, using Dax is like learning to walk , while you felt you were a champion runner in Excel...

Phil_Seamark Super Contributor
Super Contributor

Re: Dax or M Language

I reckon where there is overlap and it can be done both in DAX or M, then do it in M.  

 

The less computing the published model has to do the better.  


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

AAbdelkader Regular Visitor
Regular Visitor

Re: Dax or M Language

much replies with great useful points of view. I decided to learn both, but I will start with DAX language. Hope if it will be the best decision.

 

thanks a lot for every reply. 

DoubleJ Member
Member

Re: Dax or M Language

A scenario that might not be a common one but still worth considering: If you plan to transfer your Power BI Model into SSAS Tabular mode in a later stage you should not use Power Query (M) functionality as it is not supported in SSAS.