Power Pivot Excel | DAX - YTD measure with DATESYTD, TOTALYTD, PARALELLEPERIOD, SAMEPERIODLASTYEAR Скачать
Power Query Excel | M CODE - Text.Split/SplitAny vs Splitter.SplitByDellimiter/SplitByAnyDelimiter Скачать
Power Query & Power Pivot Excel | Query Optimisation - Turn flat file into Star Schema Data Model Скачать
XLOOKUP or INDEX in Power Query Excel (NO CODE | M CODE - Month on Month and Year on Year example) Скачать
Power Query (Excel) + M Code | Add a SUBTOTAL or TOTAL column DYNAMICALLY and based on CONDITION Скачать
Power Query (Excel) + M Code | Add Custom Columns (multi) with List. Accumulate and nested M code Скачать
Power Query (Excel) + M Code | Create CALENDAR with SEQUENCE, List.Numbers, & M code Calendar Table Скачать
Power Query (Excel) | Dynamic and conditional source import from local drive and SharePoint or Web. Скачать
Power Query (Excel) | Combine files: different file path, inconsistent format | M Code & Function Скачать
Power Query Tutorials (Excel) | 6. 10 Basic Tips (Data Type, Query Load Options, Regional Settings) Скачать
Power Query Tutorials (Excel) | 3. Data Transformation (Pivot | Unpivot, split columns, Group By) Скачать