cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
mpi_gov_vn
Frequent Visitor

What does the symbol () , =>, _ mean in M expression?

Hi guys,

 

I was reading an article on how to use List.Generate function. It mentions the symbols like "()", "=>" and "_" that I do not understand the meaning. Here's an example:

 

 

List.Generate(() => 10, each _ > 0, each _ - 1)

 

 

Could you help me explain this? Or better, is there a documentation to this? Thank you.

 

Reference: https://docs.microsoft.com/en-us/powerquery-m/list-generate

1 ACCEPTED SOLUTION
AlB
Super User
Super User

Hi @mpi_gov_vn 

You use ( )=> to declare (the start of) a function without input arguments in M. 

Check this out: https://docs.microsoft.com/en-us/powerquery-m/m-spec-functions

 

As for _  ,each is equivalent to

(_)=>

i.e. declaring (the start of) a function where _ is the input argument to the function

Read this excellent article to know more about each and _

https://www.excelguru.ca/blog/2018/01/09/each-keyword-power-query/

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

 

View solution in original post

2 REPLIES 2
AlB
Super User
Super User

Hi @mpi_gov_vn 

You use ( )=> to declare (the start of) a function without input arguments in M. 

Check this out: https://docs.microsoft.com/en-us/powerquery-m/m-spec-functions

 

As for _  ,each is equivalent to

(_)=>

i.e. declaring (the start of) a function where _ is the input argument to the function

Read this excellent article to know more about each and _

https://www.excelguru.ca/blog/2018/01/09/each-keyword-power-query/

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

 

SU18_powerbi_badge

 

Thanks @AlB , that hit the spot!

Helpful resources

Announcements
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors