Forum Discussion
Good source of PQ/M language help?
- 6 years ago
Hi shill1000
Please see the below links to the youtube videos, it's a good start.
https://www.youtube.com/watch?v=oHR73-zAMpI
https://www.youtube.com/watch?v=_zEmTGHV3UM&t=2198s
https://www.youtube.com/watch?v=TpujELq3Iug&t=2090s
https://www.youtube.com/watch?v=IdwmH-6ED60
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn - 6 years ago
Your best bet is to look at the language spec:
It is pretty compresentitive as far as the syntax goes.
- 6 years ago
Hi shill1000 ,
If you want to get dynamic date range in M code, you could try to use parameter in it. You could refert to Pass parameter to SQL Queries statement using Power BI for details.
In addition, you also could refer to Introduction To Power Query M Code and basics-of-m-power-query-formula-language or other toturial in YouTube for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Your best bet is to look at the language spec:
It is pretty compresentitive as far as the syntax goes.
- shill10006 years ago
Helper IV
Thanks that helps but its a dry document and not easy to navigate. I was looking something a bit more structured, particularly with practical examples.
i.e. one of the things I struggle with is the syntax for non-basic date handling. Most of the basic documentation only describes standard scenarios, but I struggle to find good help with things like dynamic date ranges such as fetching data in the previous x whole months. I could do it in SQL OK, but the syntax in M is more complex.
FYI I've shelled out for this as it has good reviews and I tend to find the MS books generally well laid out with good examples and sample files. But they too can be a bit dry and hard to navigate for specific help.
I get the impression there are a plethora of resources for Excel, Power BI and Dax, but far less for M.
- dax6 years ago
Community Support
Hi shill1000 ,
If you want to get dynamic date range in M code, you could try to use parameter in it. You could refert to Pass parameter to SQL Queries statement using Power BI for details.
In addition, you also could refer to Introduction To Power Query M Code and basics-of-m-power-query-formula-language or other toturial in YouTube for details.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.