Ethan GuyantThe DAX Function Universe: A Guide to Navigating the Data Analysis Tool boxUnlock the Full Potential of Your Data with DAX: From Basic Aggregations to Advanced Time IntelligenceSep 14, 2023Sep 14, 2023
Ethan GuyantFrom Data to Insights: Maximizing Power BI’s Calculated Measures and Columns for Deeper AnalysisJun 29, 20231Jun 29, 20231
Ethan GuyantUnleashing the Power of Power Query: A Guide to Power Query in Power BIDiscover the power of Power Query in Power BI with this guide. Learn how to optimize data preparation, transformation, and anaJun 21, 2023Jun 21, 2023
Ethan GuyantPower BI — Key Differences Between Data Connectivity ModesExplore Import, DirectQuery, and Live Connection Power BI connectivity modes.Apr 23, 2023Apr 23, 2023
Ethan GuyantPower BI Context Transition: Navigating the Transition between Row and Filter ContextsWhat it is and Why you need to know itNov 8, 2022Nov 8, 2022
Ethan GuyantPower BI Filter Context: Unraveling the Impact of Filters on CalculationsFilter Context — How to create it and its impact on measuresOct 24, 2022Oct 24, 2022
Ethan GuyantPower BI Iterators: Unleashing the Power of Iteration in Power BI CalculationsIterator Functions — What they are and What they doOct 11, 2022Oct 11, 2022
Ethan GuyantPower BI Row Context: Understanding the Power of Context in CalculationsRow Context — What it is, When it is invoked, and its ImplicationsSep 28, 2022Sep 28, 2022
Ethan GuyantPandas: Data TransformationPandas is a data analysis and manipulation library which provides three fundamental data structures: Index, Series, and DataFrame.Aug 18, 2022Aug 18, 2022
Ethan GuyantPandas: Indexing and SlicingThis article focuses on selecting, indexing, and slicing DataFrame objects using the indexing operator [] and the .iloc and .loc attributeJun 17, 2022Jun 17, 2022