Please note javascript is required for full website functionality.
MVP

Power Pivot Principles Blog Series

Power Pivot Principles Blog Series

 

Here is a complete list and respective links to all of our Power Pivot blogs:

  1. Power Pivot Principles: Introduction
  2. Power Pivot Principles: Excel Compatibility
  3. Power Pivot Principles: Importing Data
  4. Power Pivot Principles: Importing Data from Excel
  5. Power Pivot Principles: Filtered Imports
  6. Power Pivot Principles: Importing from an Access Database
  7. Power Pivot Principles: Importing from an Access Database (Continued) and Formatting Data
  8. Power Pivot Principles: Creating Relationships
  9. Power Pivot Principles: Menu Options
  10. Power Pivot Principles: A Design for Life
  11. Power Pivot Principles: Advancing the Series
  12. Power Pivot Principles: Power Pivot Menu in Excel
  13. Power Pivot Principles: Tables, Fields and Measures
  14. Power Pivot Principles: Calculated Columns
  15. Power Pivot Principles: Introducing Measures and Aggregations
  16. Power Pivot Principles: Recognising Measures
  17. Power Pivot Principles: Measure Creation in Practice
  18. Power Pivot Principles: Drawing a BLANK on Error Traps
  19. Power Pivot Principles: Power PivotTables
  20. Power Pivot Principles: Introducing CALCULATE
  21. Power Pivot Principles: Doing More with CALCULATE
  22. Power Pivot Principles: Caution when Negating Formulae
  23. Power Pivot Principles: Introducing ALL
  24. Power Pivot Principles: ALLEXCEPT
  25. Power Pivot Principles: ALLSELECTED
  26. Power Pivot Principles: Power PivotTables with Multiple Tables
  27. Power Pivot Principles: Filters
  28. Power Pivot Principles: Multiple Table Management
  29. Power Pivot Principles: Introducing Slicers
  30. Power Pivot Principles: Tidying Data
  31. Power Pivot Principles: Calculating with Other Tables
  32. Power Pivot Principles: Disconnected Tables and Exchange Rates
  33. Power Pivot Principles: Filters Revisited
  34. Power Pivot Principles: Calendar Table
  35. Power Pivot Principles: Basic Use of Calendar Table
  36. Power Pivot Principles: Introducing the DATESYTD Function
  37. Power Pivot Principles: Introducing the TOTALYTD Function
  38. Power Pivot Principles: How to Refresh Data in Power Pivot
  39. Power Pivot Principles: Introducing the CLOSINGBALANCEMONTH Function
  40. Power Pivot Principles: Importance of Contiguous Dates
  41. Power Pivot Principles: Tips on Calculated Columns
  42. Power Pivot Principles: Perspectives
  43. Power Pivot Principles: Resource Management with Calculated Columns
  44. Power Pivot Principles: DAX Requirements – Fully Qualified Names
  45. Power Pivot Principles: DAX Syntax Requirements – Naming Conventions
  46. Power Pivot Principles: Introducing the DATEADD Function
  47. Power Pivot Principles: Introducing the IN Function
  48. Power Pivot Principles: Concatenating Filters
  49. Power Pivot Principles: How to Combine Three or More Filter Criteria into One CALCULATE Measure
  50. Power Pivot Principles: Lookups in Power Pivot
  51. Power Pivot Principles: When the CALCULATE Function Misbehaves
  52. Power Pivot Principles: KEEPFILTERS to the Rescue
  53. Power Pivot Principles: Variables in DAX
  54. Power Pivot Principles: Variables and Disconnected Tables in Power BI
  55. Power Pivot Principles: Variables and Disconnected Tables in Power Pivot
  56. Power Pivot Principles: Revisiting the SUM Function
  57. Power Pivot Principles: Introducing the SUMX Function
  58. Power Pivot Principles: Introducing the CALCULATETABLE Function
  59. Power Pivot Principles: Introducing the DIVIDE Function
  60. Power Pivot Principles: How to Create the CAGR Measure, Part 1
  61. Power Pivot Principles: How to Create the CAGR Measure, Part 2
  62. Power Pivot Principles: How to Create the CAGR Measure, Part 3
  63. Power Pivot Principles: Conditional Custom Columns Using IF, AND, and ‘&&’
  64. Power Pivot Principles: Conditional Custom Columns Using IF, OR, and "||"
  65. Power Pivot Principles: Conditional Custom Columns with Four Categories
  66. Power Pivot Principles: MAXX
  67. Power Pivot Principles: MAXX with Filter Criteria
  68. Power Pivot Principles: Introducing the MEDIAN Function
  69. Power Pivot Principles: Introducing the MEDIANX Function
  70. Power Pivot Principles: Introducing the SWITCH Function
  71. Power Pivot Principles: Introducing the NOT Function
  72. Power Pivot Principles: Introducing the CONCATENATE Function
  73. Power Pivot Principles: Introducing the SEARCH Function
  74. Power Pivot Principles: Grouping Text Columns with New Categories
  75. Power Pivot Principles: Introducing the LASTNONBLANK Function
  76. Power Pivot Principles: Grouping Text Columns with New Categories Dynamically using an Input Table
  77. Power Pivot Principles: Grouping Text Columns with New Categories Dynamically using an Input Table – Part 2
  78. Power Pivot Principles: Introducing the RANKX Function
  79. Power Pivot Principles: Dynamic Ranking based on Selection Filters
  80. Power Pivot Principles: Introducing the DATESINPERIOD Function
  81. Power Pivot Principles: Introducing the LASTDATE Function
  82. Power Pivot Principles: Dynamic Ranges for Rolling Averages
  83. Power Pivot Principles: Dynamic Ranges and Periods for Rolling Averages
  84. Power Pivot Principles: Highlighting Absent Students
  85. Power Pivot Principles: Introducing the EARLIER Function
  86. Power Pivot Principles: Cumulative Totals with the EARLIER Function
  87. Power Pivot Principles: Calculating Cumulative Totals with Variables
  88. Power Pivot Principles: Introducing the REPLACE Function
  89. Power Pivot Principles: Introducing the SUBSTITUTE Function
  90. Power Pivot Principles: Properly Calculating Weighted Totals with the ISFILTERED Function
  91. Power Pivot Principles: Introducing the HASONEVALUE Function
  92. Power Pivot Principles: Introducing the SUMMARIZE Function
  93. Power Pivot Principles: Creating a Calendar Table
  94. Power Pivot Principles: Introducing the SAMEPERIODLASTYEAR Function
  95. Power Pivot Principles: Selecting from Multiple Lookup Values
  96. Power Pivot Principles: Introducing the CROSSFILTER Function
  97. Power Pivot Principles: Understanding Functions for Parent-Child Hierarchies in DAX – Part 1
  98. Power Pivot Principles: Understanding Functions for Parent-Child Hierarchies in DAX – Part 2
  99. Power Pivot Principles: Understanding Functions for Parent-Child Hierarchies in DAX – Part 3
  100. Power Pivot Principles: Introducing the Function LOOKUPVALUE
  101. Power Pivot Principles: Understanding Functions for Parent-Child Hierarchies in DAX – Part 4
  102. Power Pivot Principles: Introducing the ADDCOLUMNS Function
  103. Power Pivot Principles: Introducing the DATESBETWEEN Function
  104. Power Pivot Principles: Counting Working Days
  105. Power Pivot Principles: Introducing the Function INTERSECT
  106. Power Pivot Principles: Introducing the Function DISTINCTCOUNT
  107. Power Pivot Principles: Introducing the Function CROSSJOIN
  108. Power Pivot Principles: Introducing the Function PARALLELPERIOD
  109. Power Pivot Principles: Bidirectional Relationships in Power Pivot
  110. Power Pivot Principles: Parameter Table
  111. Power Pivot Principles: Introducing the Function CROSSFILTER
  112. Power Pivot Principles: Ambiguity of Birectional Relationships in Power BI
  113. Power Pivot Principles: Using ADDCOLUMNS to Create a Calendar Table
  114. Power Pivot Principles: Using SELECTCOLUMNS to Create a Calendar Table
  115. Power Pivot Principles: Using USERELATIONSHIP to Activate an Inactive Relationship
  116. Power Pivot Principles: Introduce the Function FIRSTNONBLANK
  117. Power Pivot Principles: PPP: Using DAX Studio to Return a Table Expression
  118. Power Pivot Principles: Finding the Top N Values in a Dataset
  119. Power Pivot Principles: Sorting Financial Year Months in Power Pivot
  120. Power Pivot Principles: Accurate Totals
  121. Power Pivot Principles: Duplicate Column Names
  122. Power Pivot Principles: Is There Anything RELATED?
  123. Power Pivot Principles: RELATED vs LOOKUPVALUE
  124. Power Pivot Principles: Introducing the RELATEDTABLE Function
  125. Power Pivot Principles: Introducing the DISTINCT Function
  126. Power Pivot Principles: DISTINCT vs DISTINCTCOUNT
  127. Power Pivot Principles: Introducing the VALUES Function
  128. Power Pivot Principles: DISTINCT vs VALUES
  129. Power Pivot Principles: Introducing the PREVIOUSDAY / MONTH / QUARTER / YEAR Functions
  130. Power Pivot Principles: Introducing the FILTER Function
  131. Power Pivot Principles: Introducing the FILTERS Function
  132. Power Pivot Principles: ISCROSSFILTERED vs ISFILTERED Functions
  133. Power Pivot Principles: Introducing the HASONEFILTER Function
  134. Power Pivot Principles: HASONEFILTER vs. HASONEVALUE vs. ISFILTERED
  135. Power Pivot Principles: Irregular Month-End Reporting Case - Part 1
  136. Power Pivot Principles: Irregular Month-End Reporting Case - Part 2
  137. Power Pivot Principles: Irregular Month-End Reporting Case - Part 3
  138. Power Pivot Principles: Irregular Month-End Reporting Case - Part 4
  139. Power Pivot Principles: Irregular Month-End Reporting Case - Part 5
  140. Power Pivot Principles: Irregular Month-End Reporting Case - Part 6
  141. Power Pivot Principles: SWITCH with an Expression
  142. Power Pivot Principles: Introducing the ALLNOBLANKROW Function
  143. Power Pivot Principles: Using the ALLNOBLANKROW Function to Calculate The Percentage of Total
  144. Power Pivot Principles: Introducing the REMOVEFILTERS Function in DAX
  145. Power Pivot Principles: Working with Averages - Part 1
  146. Power Pivot Principles: Working with Averages - Part 2
  147. Power Pivot Principles: Introduction to Key Performance Indicators (KPI) in Power Pivot
  148. Power Pivot Principles: Using Measures to Define Target Value in KPIs
  149. Power Pivot Principles: Getting the Measure of a Measure - Multiple Measure Management
  150. Power Pivot Principles: Problems with 1 Month Ago - DATEADD vs PREVIOUSMONTH
  151. Power Pivot Principles: Nothing to Draw a BLANK About - ISBLANK Zero?
  152. Power Pivot Principles: Size can be Everything
  153. Power Pivot Principles: Creating PivotCharts from the Power Pivot Data Model
  154. Power Pivot Principles: More PivotCharts from the Power Pivot Data Model
  155. Power Pivot Principles: SWITCH the Slicer
  156. Power Pivot Principles: Slicers for Columns - Part 1
  157. Power Pivot Principles: Slicers for Columns - Part 2
  158. Power Pivot Principles: Hiding Subtotals
  159. Power Pivot Principles: Summarising a Budget
  160. Power Pivot Principles: Calculating Measures

 

This list will be updated accordingly!

Newsletter