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

Very basic, when use # ? (M language)

Hi, I read documentation but can't find explanation for what mean # and when I need to use it. I se its use for variable name with space... but I saw more this symbol in code something like #date() I suspect what its use for data type... but I can't find some explanation, can you help me with some link to doc or some explanation?

1 ACCEPTED SOLUTION

Hi @kimalto452 ,

unfortunatels this is used in too many different ways.

You can read more about its role as an escape sign and part of identifiers here: https://docs.microsoft.com/en-us/powerquery-m/m-spec-lexical-structure

But they are also using it in some function names, which I find very unfortunate as well. Documentation about this can only be found in the function documentation itself: https://docs.microsoft.com/en-us/powerquery-m/sharptable

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @kimalto452 ,

 

Is what @ImkeF provided helpful?

 

If it is, please accept her reply as the solution. Your contribution is highly appreciated.

 

If not, please let us know.

 

 

Best Regards,

Icey

 

 

Super User IV
Super User IV

@ImkeF , Can you help with this?

 

@kimalto452 , You can refer to this in-between: https://radacad.com/basics-of-m-power-query-formula-language



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Hi @kimalto452 ,

unfortunatels this is used in too many different ways.

You can read more about its role as an escape sign and part of identifiers here: https://docs.microsoft.com/en-us/powerquery-m/m-spec-lexical-structure

But they are also using it in some function names, which I find very unfortunate as well. Documentation about this can only be found in the function documentation itself: https://docs.microsoft.com/en-us/powerquery-m/sharptable

 

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors