Adding Parameter in Data Table M Function - Query Editor Tutorial
This video is going to Illustrate how to set up and incorporate an additional Parameter to the Power Query Date Table M function.
Hope you enjoy this one
Melissa
Date table M code: https://forum.enterprisedna.co/t/exte...
**** Video Details ****
1:45 copy the date table M function from the M Showcase Category in the Enterprise DNA Forum
2:00 the Extended Date Table in the forum
2:19 set up logic in a new blank Query and
5:51 create a logical test using List.Contains
7:55 incorporate the fcorrect logic into Distinct.Table
9:14 invoke the query
***** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
**** Related Links ****
Using The M Function To Create An Extended Power BI Date Table - https://blog.enterprisedna.co/using-t...
Beginners’ Guide To The M Code In Power BI - https://blog.enterprisedna.co/beginne...
Setting Up A Dynamic StartDate And EndDate For Power Query Date Tables - https://blog.enterprisedna.co/setting...
**** Related Course Modules ****
Advanced Data Transformations & Modeling - https://portal.enterprisedna.co/p/adv...
Power Query Series - https://portal.enterprisedna.co/p/pow...
Best Practices & Feature Reviews - https://portal.enterprisedna.co/cours...
**** Related Support Forum Posts ****
Extended Date Table (Power Query M Function) - https://forum.enterprisedna.co/t/exte...
Time Table (Power Query M Function) - https://forum.enterprisedna.co/t/time...
13 Period Fiscal Calendar (Power Query M Function) - https://forum.enterprisedna.co/t/13-p...
For more M function support queries to review see here - https://forum.enterprisedna.co/search...
On this page of the site you can watch the video online Adding Parameter in Data Table M Function - Query Editor Tutorial with a duration of hours minute second in good quality, which was uploaded by the user Enterprise DNA 14 July 2020, share the link with friends and acquaintances, this video has already been watched 5,303 times on youtube and it was liked by 61 viewers. Enjoy your viewing!
