Good source of PQ/M language help?

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

Your best bet is to look at the language spec:

https://download.microsoft.com/download/8/1/A/81A62C9B-04D5-4B6D-B162-D28E4D848552/Power%20Query%20M%20Formula%20Language%20Specification%20(July%202019).pdf 

It is pretty compresentitive as far as the syntax goes.

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 Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.