Power Pivot Principles Blog Series
Here is a complete list and respective links to all of our Power Pivot blogs:
- Introduction
- Excel Compatibility
- Importing Data
- Importing Data from Excel
- Filtered Imports
- Importing from an Access Database
- Importing from an Access Database (Continued) and Formatting Data
- Creating Relationships
- Menu Options
- A Design for Life
- Advancing the Series
- Power Pivot Menu in Excel
- Tables, Fields and Measures
- Calculated Columns
- Introducing Measures and Aggregations
- Recognising Measures
- Measure Creation in Practice
- Drawing a BLANK on Error Traps
- Power PivotTables
- Introducing CALCULATE
- Doing More with CALCULATE
- Caution when Negating Formulae
- Introducing ALL
- ALLEXCEPT
- ALLSELECTED
- Power PivotTables with Multiple Tables
- Filters
- Multiple Table Management
- Introducing Slicers
- Tidying Data
- Calculating with Other Tables
- Disconnected Tables and Exchange Rates
- Filters Revisited
- Calendar Table
- Basic Use of Calendar Table
- Introducing the DATESYTD Function
- Introducing the TOTALYTD Function
- How to Refresh Data in Power Pivot
- Introducing the CLOSINGBALANCEMONTH Function
- Importance of Contiguous Dates
- Tips on Calculated Columns
- Perspectives
- Resource Management with Calculated Columns
- DAX Requirements – Fully Qualified Names
- DAX Syntax Requirements – Naming Conventions
- Introducing the DATEADD Function
- Introducing the IN Function
- Concatenating Filters
- How to Combine Three or More Filter Criteria into One CALCULATE Measure
- Lookups in Power Pivot
- When the CALCULATE Function Misbehaves.
- KEEPFILTERS to the Rescue
- Variables in DAX
- Variables and Disconnected Tables in Power BI
- Variables and Disconnected Tables in Power Pivot
- Revisiting the SUM function
- Introducing the SUMX function
- Introducing the CALCULATETABLE Function
- Introducing the DIVIDE Function
- How to Create the CAGR Measure, Part 1
- How to Create the CAGR Measure, Part 2
- How to Create the CAGR Measure, Part 3
- Conditional Custom Columns Using IF, AND, and ‘&&’
- Conditional Custom Columns Using IF, OR and ‘||’
- Conditional Custom Columns with Four Categories
- MAXX
- MAXX with Filter Criteria
- Introducing the MEDIAN Function
- Introducing the MEDIANX Function
- Introducing the SWITCH Function
- Introducing the NOT Function
- Introducing the CONCATENATE Function
- Introducing the SEARCH Function
- Grouping Text Columns with New Categories
- Introducing the LASTNONBLANK Function
- Grouping Text Columns with New Categories Dynamically using an Input Table
- Grouping Text Columns with New Categories Dynamically using an Input Table – Part 2
- Introducing the RANKX Function
- Dynamic Ranking based on Selection Filters
- Introducing the DATESINPERIOD Function
- Introducing the LASTDATE Function
- Dynamic Ranges for Rolling Averages
- Dynamic Ranges and Periods for Rolling Averages
- Highlighting Absent Students
- Introducing the EARLIER Function
- Cumulative Totals with the EARLIER Function
- Calculating Cumulative Totals with Variables
- Introducing the REPLACE Function
- Introducing the SUBSTITUTE Function
- Properly Calculating Weighted Totals with the ISFILTERED Function
- Power Pivot Principles : Introducing the HASONEVALUE Function
- Introducing the SUMMARIZE Function
- Power Pivot Principles : Creating a Calendar Table
- Introducing the SAMEPERIODLASTYEAR Function
- Selecting from Multiple Lookup Values
- Introducing the CROSSFILTER Function
- Understanding functions for parent-child hierarchies in DAX – Part 1
- Understanding Functions for Parent-Child Hierarchies in DAX – Part 2
- Understanding Functions for Parent-Child Hierarchies in DAX – Part 3
- Introducing the Function LOOKUPVALUE
- Understanding Functions for Parent-Child Hierarchies in DAX – Part 4
- Introducing the ADDCOLUMNS Function
- Introducing the DATESBETWEEN Function
- Counting Working Days
- Introducing the Function INTERSECT
- Introducing the Function DISTINCTCOUNT
- Introducing the Function CROSSJOIN
- Introducing the Function PARALLELPERIOD
- Bidirectional Relationships in Power Pivot
- Parameter Table
- Introducing the Function CROSSFILTER
- Ambiguity of Bidirectional Relationships in Power BI
- Using ADDCOLUMNS to Create a Calendar Table
- Using SELECTCOLUMNS to Create Calendar Table
- Using USERELATIONSHIP to Activate an Inactive Relationship
- Introducing the Function FIRSTNONBLANK
- Using DAX Studio to Return a Table Expression
- Finding the Top N Values in a Dataset
- Sorting Financial Year Months in Power Pivot
- Accurate Totals
- Duplicate Column Names
- Is there anything RELATED?
- RELATED vs LOOKUPVALUE
- Power Pivot Principle: Introducing the RELATEDTABLE function
- Introducing the DISTINCT function
- DISTINCT vs. DISTINCTCOUNT
- Introducing the VALUES Function
- DISTINCT vs. VALUES
- Introducing the PREVIOUSDAY / MONTH / QUARTER / YEAR Functions
- Introducing the FILTER Function
- The A to Z of DAX Functions – ADDCOLUMNS
- Introducing the FILTERS Function
- ISCROSSFILTERED vs ISFILTERED Functions
- Introducing the HASONEFILTER Function
- HASONEFILTER vs. HASONEVALUE vs. ISFILTERED
- Irregular Month-End Reporting Case – Part 1
- Irregular Month-End Reporting Case – Part 2
- Irregular Month-End Reporting Case – Part 3
- Irregular Month-End Reporting Case – Part 4
- Irregular Month-End Reporting Case – Part 5
- Irregular Month-End Reporting Case – Part 6
- SWITCH with an Expression
- Introducing the ALLNOBLANKROW Function
- Using the ALLNOBLANKROW Function to Calculate The Percentage of Total
- Introducing the REMOVEFILTERS Function in DAX
- Working with Averages – Part 1
- Working with Averages – Part 2
- Introduction to Key Performance Indicators (KPIs) in Power Pivot
- Using Measures to Define Target Value in KPIs
- Getting the Measure of a Measure – Multiple Measure Management
- Problems with 1 Month Ago – DATEADD vs. PREVIOUSMONTH
- Nothing to Draw a BLANK About – ISBLANK Zero?
- Size Can Be Everything
- Creating PivotCharts from the Power Pivot Data Model
- More PivotCharts from the Power Pivot Data Model
- SWITCH the Slicer
- Slicers for Columns – Part 1
- Slicers for Columns – Part 2
- Hiding Subtotals
- Summarising a Budget
- Calculating Measures
- Amendments Made Easily
- Creating a Disconnected Table for GST
- Sensitivity Analysis
- Budget vs Actuals
- Credit Transactions
- Data Cleansing
- Bridging the Gaps
- How Did I Bridge the Gaps?
- Slicing the Bridge
- Annual / Monthly Comparisons
- DATEADD Comparison
- PARALLELPERIOD Comparison
- PREVIOUSMONTH Comparison
- PREVIOUSQUARTER Comparison
- COGS and COGS Cash Payments
- Initial Measures – a Pro Tip
- Calculated Field vs. Measure
- The A to Z of DAX Functions – ABS
- The A to Z of DAX Functions – ACOS
- The A to Z of DAX Functions – ACOSH
- The A to Z of DAX Functions – ACOT
- The A to Z of DAX Functions – ACOTH
- The A to Z of DAX Functions – ADDMISSINGITEMS
- The A to Z of DAX Functions – ALL
- The A to Z of DAX Functions – ALLEXCEPT
- The A to Z of DAX Functions – ALLNOBLANKROW
- The A to Z of DAX Functions – ALLSELECTED
- The A to Z of DAX Functions – AND
- The A to Z of DAX Functions – ASIN
- The A to Z of DAX Functions – ASINH
- The A to Z of DAX Functions – ATAN
- The A to Z of DAX Functions – ATANH
- The A to Z of DAX Functions – AVERAGE
- The A to Z of DAX Functions – AVERAGEA
- The A to Z of DAX Functions – AVERAGEX
- The A to Z of DAX Functions – BETA.DIST
- The A to Z of DAX Functions – BETA.INV
- The A to Z of DAX Functions – BLANK
- The A to Z of DAX Functions – CALCULATE
- The A to Z of DAX Functions – CALCULATETABLE
- The A to Z of DAX Functions – CALENDAR
- The A to Z of DAX Functions – CALENDARAUTO
- Generating a List of Measure Descriptions
- The A to Z of DAX Functions – CEILING
- The A to Z of DAX Functions – CHISQ.DIST
- The A to Z of DAX Functions – CHISQ.DIST.RT
- The A to Z of DAX Functions – CHISQ.INV
- The A to Z of DAX Functions – CHISQ.INV.RT
- The A to Z of DAX Functions – CLOSINGBALANCEMONTH
- The A to Z of DAX Functions – CLOSINGBALANCEQUARTER
- The A to Z of DAX Functions – CLOSINGBALANCEYEAR
- The A to Z of DAX Functions – ACCRINT
- The A to Z of DAX Functions – ACCRINTM
- The A to Z of DAX Functions – ALLCROSSFILTERED
- The A to Z of DAX Functions – AMORDEGRC
- The A to Z of DAX Functions – AMORLINC
- The A to Z of DAX Functions – APPROXIMATEDISTINCTCOUNT
- The A to Z of DAX Functions – BITAND
- The A to Z of DAX Functions – BITLSHIFT
- The A to Z of DAX Functions – BITOR
- The A to Z of DAX Functions – BITRSHIFT
- The A to Z of DAX Functions – BITXOR
- The A to Z of DAX Functions – COALESCE
- The A to Z of DAX Functions – COMBIN
- The A to Z of DAX Functions – COMBINA
- The A to Z of DAX Functions – COMBINEVALUES
- The A to Z of DAX Functions – CONCATENATE
- The A to Z of DAX Functions – CONCATENATEX
- The A to Z of DAX Functions – CONFIDENCE.NORM
- The A to Z of DAX Functions – CONFIDENCE.T
- The A to Z of DAX Functions – CONTAINS
- The A to Z of DAX Functions – CONTAINSROW
- The A to Z of DAX Functions – CONTAINSSTRING
- The A to Z of DAX Functions – CONTAINSSTRINGEXACT
- The A to Z of DAX Functions – CONVERT
- The A to Z of DAX Functions – COS
- The A to Z of DAX Functions – COSH
- The A to Z of DAX Functions – COT
- The A to Z of DAX Functions – COTH
- The A to Z of DAX Functions – COUNT
- The A to Z of DAX Functions – COUNTA
- The A to Z of DAX Functions – COUNTAX
- The A to Z of DAX Functions – COUNTBLANK
- The A to Z of DAX Functions – COUNTROWS
- The A to Z of DAX Functions – COUNTX
- The A to Z of DAX Functions – COUPDAYBS
- The A to Z of DAX Functions – COUPDAYS
- The A to Z of DAX Functions – COLUMNSTATISTICS
- The A to Z of DAX Functions – COUPDAYSNC
- The A to Z of DAX Functions – COUPNCD
- The A to Z of DAX Functions – COUPNUM
- The A to Z of DAX Functions – COUPPCD
- The A to Z of DAX Functions – CROSSFILTER
- The A to Z of DAX Functions – CROSSJOIN
- The A to Z of DAX Functions – CUMIPMT
- The A to Z of DAX Functions – CUMPRINC
- The A to Z of DAX Functions – CURRENCY
- The A to Z of DAX Functions – CURRENTGROUP
- The A to Z of DAX Functions – CUSTOMDATA
- The A to Z of DAX Functions – DATATABLE
- The A to Z of DAX Functions – DATE
- The A to Z of DAX Functions – DATEADD
- The A to Z of DAX Functions – DATEDIFF
- The A to Z of DAX Functions – DATESBETWEEN
- The A to Z of DAX Functions – DATESINPERIOD
- The A to Z of DAX Functions – DATESMTD
- The A to Z of DAX Functions – DATESQTD
- The A to Z of DAX Functions – DATESYTD
- The A to Z of DAX Functions – DATEVALUE
- The A to Z of DAX Functions – DAY
- The A to Z of DAX Functions – DB
- The A to Z of DAX Functions – DDB
- The A to Z of DAX Functions – DEFINE
- The A to Z of DAX Functions – DEGREES
- The A to Z of DAX Functions – DETAILROWS
- The A to Z of DAX Functions – DISC
- The A to Z of DAX Functions – DISTINCT(column)
- The A to Z of DAX Functions – DISTINCT(table)
- The A to Z of DAX Functions – DISTINCTCOUNT
- The A to Z of DAX Functions – DISTINCTCOUNTNOBLANK
- The A to Z of DAX Functions – DIVIDE
- The A to Z of DAX Functions – DOLLARDE
- The A to Z of DAX Functions – DOLLARFR
- The A to Z of DAX Functions – DURATION
- The A to Z of DAX Functions – EARLIER
- The A to Z of DAX Functions – EARLIEST
- The A to Z of DAX Functions – EDATE
- The A to Z of DAX Functions – EFFECT
- The A to Z of DAX Functions – ENDOFMONTH
- The A to Z of DAX Functions – ENDOFQUARTER
- The A to Z of DAX Functions – ENDOFYEAR
- The A to Z of DAX Functions – EOMONTH
- The A to Z of DAX Functions – ERROR
- The A to Z of DAX Functions – EVALUATE
- The A to Z of DAX Functions – EVALUATEANDLOG
- The A to Z of DAX Functions – EVEN
- The A to Z of DAX Functions – EXACT
- The A to Z of DAX Functions – EXCEPT
- The A to Z of DAX Functions – EXP
- The A to Z of DAX Functions – EXPON.DIST
- The A to Z of DAX Functions – FACT
- The A to Z of DAX Functions – FALSE
- The A to Z of DAX Functions – FILTER
- The A to Z of DAX Functions – FILTERS
- The A to Z of DAX Functions – FIND
- The A to Z of DAX Functions – FIRSTDATE
- The A to Z of DAX Functions – FIRSTNONBLANK
- The A to Z of DAX Functions – FIRSTNONBLANKVALUE
- The A to Z of DAX Functions – FIXED
- The A to Z of DAX Functions – FLOOR
- The A to Z of DAX Functions – FORMAT
- The A to Z of DAX Functions – FV
- The A to Z of DAX Functions – GCD
- The A to Z of DAX Functions – GENERATE
- The A to Z of DAX Functions – GENERATEALL
- The A to Z of DAX Functions – GENERATESERIES
- The A to Z of DAX Functions – GEOMEAN
- The A to Z of DAX Functions – GEOMEANX
- The A to Z of DAX Functions – GROUPBY
- The A to Z of DAX Functions – HASONEFILTER
- The A to Z of DAX Functions – HASONEVALUE
- The A to Z of DAX Functions – HOUR
- The A to Z of DAX Functions – IF
- The A to Z of DAX Functions – IF.EAGER
- The A to Z of DAX Functions – IFERROR
- The A to Z of DAX Functions – IGNORE
- The A to Z of DAX Functions – INDEX
- The A to Z of DAX Functions – INFO.ALTERNATEOFDEFINITIONS
- The A to Z of DAX Functions – INFO.ANNOTATIONS
- The A to Z of DAX Functions – INFO.ATTRIBUTEHIERARCHIES
- The A to Z of DAX Functions – INFO.ATTRIBUTEHIERARCHYSTORAGES
- The A to Z of DAX Functions – INFO.CALCULATIONGROUPS
- The A to Z of DAX Functions – INFO.CALCULATIONITEMS
- The A to Z of DAX Functions – INFO.CHANGEDPROPERTIES
- The A to Z of DAX Functions – INFO.COLUMNPARTITIONSTORAGES
- The A to Z of DAX Functions – INFO.COLUMNPERMISSIONS
- The A to Z of DAX Functions – INFO.COLUMNS
- The A to Z of DAX Functions – INFO.COLUMNSTORAGES
- The A to Z of DAX Functions – INFO.CULTURES
- The A to Z of DAX Functions – INFO.CALCDEPENDENCY
- The A to Z of DAX Functions – INFO.DATASOURCES
- The A to Z of DAX Functions – INFO.DELTATABLEMETADATASTORAGES
- The A to Z of DAX Functions – INFO.DETAILROWSDEFINITION
- The A to Z of DAX Functions – INFO.DICTIONARYSTORAGES
- The A to Z of DAX Functions – INFO.CATALOGS
- The A to Z of DAX Functions – INFO.EXPRESSIONS
- The A to Z of DAX Functions – INFO.EXTENDEDPROPERTIES
- The A to Z of DAX Functions – INFO.FORMATSTRINGDEFINITIONS
- The A to Z of DAX Functions – INFO.FUNCTIONS
- The A to Z of DAX Functions – INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES
- The A to Z of DAX Functions – INFO.GROUPBYCOLUMNS