Excel - Data Visualization with DAX and Dynamic Array
Bsmart2gether
Excel - Data Visualization with DAX and Dynamic Array
14:51
Power Query Excel | M CODE - List.Zip Multi-Headers
Bsmart2gether
Power Query Excel | M CODE - List.Zip Multi-Headers
7:09
Power Pivot Excel | DAX - YTD measure with DATESYTD, TOTALYTD, PARALELLEPERIOD, SAMEPERIODLASTYEAR
Bsmart2gether
Power Pivot Excel | DAX - YTD measure with DATESYTD, TOTALYTD, PARALELLEPERIOD, SAMEPERIODLASTYEAR
8:43
Power Query Excel | M CODE - Text value manipulation and extraction
Bsmart2gether
Power Query Excel | M CODE - Text value manipulation and extraction
6:01
Power Pivot Excel | DAX - ALL vs ALLSELECTED vs ALLEXCEPT
Bsmart2gether
Power Pivot Excel | DAX - ALL vs ALLSELECTED vs ALLEXCEPT
7:56
Power Query Excel | M CODE - Text.Split/SplitAny vs Splitter.SplitByDellimiter/SplitByAnyDelimiter
Bsmart2gether
Power Query Excel | M CODE - Text.Split/SplitAny vs Splitter.SplitByDellimiter/SplitByAnyDelimiter
6:02
Analytical Challenge - FP20 The Mobile Phone Sales Solutions
Bsmart2gether
Analytical Challenge - FP20 The Mobile Phone Sales Solutions
13:04
Power Pivot Excel | DAX - SUM vs SUMX and SUMX + FILTER.
Bsmart2gether
Power Pivot Excel | DAX - SUM vs SUMX and SUMX + FILTER.
4:24
Power Query Excel | M CODE - List.Generate (POWERFUL fx - While loop equivalent)
Bsmart2gether
Power Query Excel | M CODE - List.Generate (POWERFUL fx - While loop equivalent)
8:12
Power Pivot Excel - Beginner - How to Import Data, calculation types & export.
Bsmart2gether
Power Pivot Excel - Beginner - How to Import Data, calculation types & export.
5:51
Power Query Excel | M CODE - Challenge Solutions with Table.Partition & List.Accumulate
Bsmart2gether
Power Query Excel | M CODE - Challenge Solutions with Table.Partition & List.Accumulate
6:40
Power Query & Power Pivot Excel | Query Optimisation - Turn flat file into Star Schema Data Model
Bsmart2gether
Power Query & Power Pivot Excel | Query Optimisation - Turn flat file into Star Schema Data Model
5:54
Power Query Excel | M CODE - Merge Queries / Join Tables (Cover all Join Tables Functions)
Bsmart2gether
Power Query Excel | M CODE - Merge Queries / Join Tables (Cover all Join Tables Functions)
8:00
Power Query Excel | M CODE - Custom Function f(x) with the example of a cumulative sum.
Bsmart2gether
Power Query Excel | M CODE - Custom Function f(x) with the example of a cumulative sum.
8:03
Power Query Excel | Error Handling
Bsmart2gether
Power Query Excel | Error Handling
8:30
XLOOKUP or INDEX in Power Query Excel (NO CODE | M CODE - Month on Month and Year on Year example)
Bsmart2gether
XLOOKUP or INDEX in Power Query Excel (NO CODE | M CODE - Month on Month and Year on Year example)
9:24
Power Query (Excel) + M Code | Self Reference - Incremental Load
Bsmart2gether
Power Query (Excel) + M Code | Self Reference - Incremental Load
6:35
Power Query (Excel) + M Code | Replace Value function beginner to advanced
Bsmart2gether
Power Query (Excel) + M Code | Replace Value function beginner to advanced
4:04
Power Query (Excel) + M Code | Dynamic Filter - No Code & M Code
Bsmart2gether
Power Query (Excel) + M Code | Dynamic Filter - No Code & M Code
4:50
Power Query (Excel) + M Code | Add a SUBTOTAL or TOTAL column DYNAMICALLY and based on CONDITION
Bsmart2gether
Power Query (Excel) + M Code | Add a SUBTOTAL or TOTAL column DYNAMICALLY and based on CONDITION
4:06
Power Query (Excel) + M Code | Combine data - Inconsistent Header (#shared & Fuzzy)
Bsmart2gether
Power Query (Excel) + M Code | Combine data - Inconsistent Header (#shared & Fuzzy)
5:55
Power Query (Excel) + M Code | Add Custom Columns (multi) with List. Accumulate and nested M code
Bsmart2gether
Power Query (Excel) + M Code | Add Custom Columns (multi) with List. Accumulate and nested M code
4:49
Power Query (Excel) + M Code | Compare multiple tables - No Code to M Code (MATCH)
Bsmart2gether
Power Query (Excel) + M Code | Compare multiple tables - No Code to M Code (MATCH)
7:08
Power Query (Excel) + M Code | Create CALENDAR with SEQUENCE, List.Numbers, & M code Calendar Table
Bsmart2gether
Power Query (Excel) + M Code | Create CALENDAR with SEQUENCE, List.Numbers, & M code Calendar Table
6:00
Power Query (Excel) + M Code | List.Accumulate; Table.ReplaceValue
Bsmart2gether
Power Query (Excel) + M Code | List.Accumulate; Table.ReplaceValue
4:29
Power Query (Excel) + M Code | GroupBy - Table.Group & Table.FuzzyGroup
Bsmart2gether
Power Query (Excel) + M Code | GroupBy - Table.Group & Table.FuzzyGroup
4:07
Power Query (Excel) + M Code | How to Cell Reference - Basic but very important!
Bsmart2gether
Power Query (Excel) + M Code | How to Cell Reference - Basic but very important!
3:52
Power Query (Excel) + M Code | List.Transform = Dynamic Changed Type and Replaced Errors
Bsmart2gether
Power Query (Excel) + M Code | List.Transform = Dynamic Changed Type and Replaced Errors
5:02
Power Query (Excel) + M Code | SUMIFS (Simple to Complex FIFO example)
Bsmart2gether
Power Query (Excel) + M Code | SUMIFS (Simple to Complex FIFO example)
12:27
Power Query (Excel) + M Code | Excel Modelling and Reporting with M
Bsmart2gether
Power Query (Excel) + M Code | Excel Modelling and Reporting with M
7:31
Power Query (Excel) + M Code | Filter Column Headers Conditionally & Dynamically + Unpivot
Bsmart2gether
Power Query (Excel) + M Code | Filter Column Headers Conditionally & Dynamically + Unpivot
4:08
Power Query (Excel) | Level up to M code from Power Query?
Bsmart2gether
Power Query (Excel) | Level up to M code from Power Query?
4:00
Power Query (Excel) | Multi Headers + Dynamic Rename (Dynamic Version). M code
Bsmart2gether
Power Query (Excel) | Multi Headers + Dynamic Rename (Dynamic Version). M code
6:37
Power Query (Excel) | Dynamic and conditional source import from local drive and SharePoint or Web.
Bsmart2gether
Power Query (Excel) | Dynamic and conditional source import from local drive and SharePoint or Web.
4:05
Power Query (Excel) | Combine files: different file path, inconsistent format | M Code & Function
Bsmart2gether
Power Query (Excel) | Combine files: different file path, inconsistent format | M Code & Function
5:35
Power Query (Excel) | Dynamic column expanding with and without conditions | M Code
Bsmart2gether
Power Query (Excel) | Dynamic column expanding with and without conditions | M Code
3:23
Power Query (Excel) | Dynamic Filtering & Parameter
Bsmart2gether
Power Query (Excel) | Dynamic Filtering & Parameter
3:45
Excel | 5 Pivot Table Tips
Bsmart2gether
Excel | 5 Pivot Table Tips
3:58
Excel | Master Pivot Table from scratch in minutes
Bsmart2gether
Excel | Master Pivot Table from scratch in minutes
7:11
Power Query Tutorials (Excel) | 6. 10 Basic Tips (Data Type, Query Load Options, Regional Settings)
Bsmart2gether
Power Query Tutorials (Excel) | 6. 10 Basic Tips (Data Type, Query Load Options, Regional Settings)
8:40
Power Query Tutorials (Excel) | 5. Error Handling, Add Custom Column and IF function
Bsmart2gether
Power Query Tutorials (Excel) | 5. Error Handling, Add Custom Column and IF function
8:26
Power Query Tutorials (Excel) | 4. Merge and Append
Bsmart2gether
Power Query Tutorials (Excel) | 4. Merge and Append
8:30
Power Query Tutorials (Excel) | 3. Data Transformation (Pivot | Unpivot, split columns, Group By)
Bsmart2gether
Power Query Tutorials (Excel) | 3. Data Transformation (Pivot | Unpivot, split columns, Group By)
8:31
Power Query Tutorials (Excel) | 2. Extract and Load (Importing and loading data into Excel
Bsmart2gether
Power Query Tutorials (Excel) | 2. Extract and Load (Importing and loading data into Excel
8:48
Power Query Tutorials (Excel) | 1. Introduction
Bsmart2gether
Power Query Tutorials (Excel) | 1. Introduction
4:07