46 тысяч подписчиков
174 видео
Power Query - List.Buffer to do a Million row Lookup
Python - Virtual Environments
Power Query - Dynamically Split into Columns
PowerBI & DAX - TopN Sales using Parameter Table (Part 4)
PowerBI - Sort by Other Column Error
Power Query - Shortcut to Remove Columns
Write more advanced DAX by auto generating Queries in DAX Studio
PowerBi & DAX - Using Parameters for Discount Scenario Analysis
PowerBI & DAX - Parameter Tables - Changing Report Scale
Power Query - Advanced grouping (Comma Delimited Values)
Power Query - Index Column by Group & Return Last and First Record for a Group
Power Query - Looping and API Calls!
Power Query - Filter Multiple Columns at once🦖😶🌫️
Power Query - Running Totals (Simple)
Power Query - Categorizing data using groups and bins
Power Query - Removing & Reporting Duplicates
Power Query - Filter Based on Column Position
Power Query - Filter Nested Table Before Expanding
Power Query - Dynamic Grouping 🥶🍔
Power BI & DAX - Simple Moving Averages
Power Query - Advanced Grouping applied to Stock Portfolio's
Power Query - Dynamically Set Query Header Titles
Power Query - Pad Text Dynamically
SSIS - Executing SQL Task and use For Each Container
Power Query - The Let-in syntax alternatives
Using Temp Table in SSIS
Power Query - Combine tables without Merging 🔗🧲
Power BI & DAX - Calculate Month on Month Change
Power Query Remove Numbers and Special Characters!
Power Query - Sentiment Analysis using ChatGPT API
Power Query - Parsing Delimited data into a table🔍
Power Query - Cumulative Totals using List.Accumulate
Power Query - Call GPT-4 API to convert Numbers 🐣
Power Query - Conditionally replace values in one step!
Power Query - Bulk Replace Values in One Step 🔄📊
Power Query - Data from many folders with Single Query
Power Query - Dealing with Errors
Power Query - Net working Days in power query
Power BI - Events in Progress Snapshots
Power Query - Previous Row Hack
Power Query - Dynamically transform column names
PowerBI - Hierarchies and ChatGPT Comparison
Power Query - Dynamically Expand Many Columns to Rows
Power Query - Extract Rows with Consecutive Numbers 📑➡️🔢
Power BI - Dynamic Ranking (Part 2)
Power Query - Dynamic Coalesce multiple columns
Power Query - Add Subtotals and Grand totals
Power Query - Advanced Transformation of Nested Tables
Power Query - Unstack a Uneven List into a Table 🍔🦖
Power Query - Unstack Uneven Rows to Columns🍔
