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

How does the M language help us in Power BI ?

Hello,

My manager wants me to learn the M language thinking it could help us with Power BI but so far

I cannot really think of a situation where I have to use the M language when importing data.

 

Can someone please tell me a few scenarios where either I have to use it or the M makes tasks a lot easier than other methods ?

 

Thanks in advance

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

Re: How does the M language help us in Power BI ?

The graphical interface is good, in fact its better than most visual programming languages that i've used.  It only gets you so far though.  There are many occasions where you simply need to pop the hood and write code yourself because the interface is limited.  I'm always using a combination of both to resolve challenges that present themselves.

 

Skills are a toolbelt.  Some tools have overlapping uses, but that doesn't invalidate their need or usefulness.  Any good craftsman relies on have the right tools for the job when the time comes.  Deliberatly leaving out a good tool will only hurt you in the long run.  Forcing yourself to simply use what is comfortable will lead you down a path of completing work that you won't be happy with and will create problems where problems don't need to exist.  "When all you have is a hammer, every problem looks like a nail".

 


   

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

Proud to be a Datanaut!


   


5 REPLIES 5
Super User
Super User

Re: How does the M language help us in Power BI ?

From a best practise perspective, M should be used wherever possible instead of creating calculated columns.  If you have a desire to create large complex projects, understanding M will be invaluable for optimising your model.


   

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

Proud to be a Datanaut!


   


hideakisuzuki Regular Visitor
Regular Visitor

Re: How does the M language help us in Power BI ?

 


@Ross73312 wrote:

From a best practise perspective, M should be used wherever possible instead of creating calculated columns.  If you have a desire to create large complex projects, understanding M will be invaluable for optimising your model.


 

But that can be done graphically in the Query Editor screen, there is no need to write the code by yourself

Super User
Super User

Re: How does the M language help us in Power BI ?

I agree with @Ross73312

 

There will come a time when having to go into the M Code will mean you have to understand how it works. There are over 900 M Functions that exist.

 

Along with that, with the new CDS-A that is coming you can leverage your M skills when importing data into CDS-A



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

"Proud to be a Datanaut!"
Highlighted
Super User
Super User

Re: How does the M language help us in Power BI ?

The graphical interface is good, in fact its better than most visual programming languages that i've used.  It only gets you so far though.  There are many occasions where you simply need to pop the hood and write code yourself because the interface is limited.  I'm always using a combination of both to resolve challenges that present themselves.

 

Skills are a toolbelt.  Some tools have overlapping uses, but that doesn't invalidate their need or usefulness.  Any good craftsman relies on have the right tools for the job when the time comes.  Deliberatly leaving out a good tool will only hurt you in the long run.  Forcing yourself to simply use what is comfortable will lead you down a path of completing work that you won't be happy with and will create problems where problems don't need to exist.  "When all you have is a hammer, every problem looks like a nail".

 


   

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

Proud to be a Datanaut!


   


Community Support Team
Community Support Team

Re: How does the M language help us in Power BI ?

Hi @hideakisuzuki,

 

Have you solved the confusion with the help?

 

If you have understood the help of M language in Power BI, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.