Create FnUnpivotSummarizedTable
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic3-create-FnUnpivotSummarizedTable.odt” comments=”true” SVG=”true”] You can download your data files here C07E02
Using FnUnpivotSummarizedTable
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic2-using-FnUnpivotSummarizedTable.odt” comments=”true” SVG=”true”] You can download your data files here C07E02
Unpivoting N×M Levels of Hierarchy 3
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses7_topic1-Unpivoting-N×M-Levels-of-Hierarchy-3.odt” comments=”true” SVG=”true”] You can download your data files here C07E01
Splitting Delimiter Separated values into rows
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic6-Seprating-Delimeter-Seprated-values-into-rows.odt” comments=”true” SVG=”true”] You can download your data files here C02E08
Handling Dates with two locales
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic5-Handlling-dates-with-two-locale.odt” comments=”true” SVG=”true”] You can download your data files here C02E06
Use and implement of Column by Example
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic4-use-and-implementation-of-Column-by-Example.odt” comments=”true” SVG=”true”] You can download your data files here C02E02
Create Relationships manually
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic3-Create-relationship-manually-1.odt” comments=”true” SVG=”true”] You can download your data files here C02E02
Managing Relationships in Power BI
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic2-Manage-relationships-in-Power-BI.odt” comments=”true” SVG=”true”] You can download your data files here C02E07
Dividing a column into multiple parts
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses2_topic1-dividing-a-column-into-multiple-parts-in-Power-BI.-2.odt” comments=”true” SVG=”true”] You can download your data files here C02E01
Perform filtering on a dataset
[docxpresso file=”https://ilmoirfan.com/wp-content/uploads/2019/11/ses1_topic4-Perform-filterng-on-a-dataset..odt” comments=”true” SVG=”true”]