Filtering out black products
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses10_topic2-filtering-out-black-products.odt” comments=”true” SVG=”true”] You can download your data files here C10E01
Using the Formula Bar to Detect Static References to Column Names
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses10_topic1-Using-the-Formula-Bar-to-Detect-Static-References-to-Column-Names.odt” comments=”true” SVG=”true”] You can download your data files here C10E01
The M Formula Language
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses9_topic3-The-M-Formula-Language.odt” comments=”true” SVG=”true”]
To print Hello World using M Language
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses9_topic2-to-print-Hello-World-using-M-Language.odt” comments=”true” SVG=”true”] C08E05 – Folder
Using #shared to Explore Built-in Functions
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/Ses9_topic-1-Using-shared-to-Explore-Built-in-Functions.odt” comments=”true” SVG=”true”] C08E01
Importing Data from Files on OneDrive for Business or SharePoint
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses8_topic3-Importing-Data-from-Files-on-OneDrive-for-Business-or-SharePoint.odt” comments=”true” SVG=”true”]
Creating Template in Power BI
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses8_topic2-Creating-Template-in-Power-BI.odt” comments=”true” SVG=”true”]
Using a parameter for a path name
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses8_topic1-using-a-parameter-for-a-path-name.odt” comments=”true” SVG=”true”]
Pivoting Tables of Multiline Records
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic5-Pivoting-Tables-of-Multiline-Records.odt” comments=”true” SVG=”true”] You can download your data files here C07E04
Reversing an incorrected Unpivoted table
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic4-Reversing-an-incorrected-Unpivoted-table.odt” comments=”true” SVG=”true”] You can download your data files here C07E04