Please note javascript is required for full website functionality.

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. Introduction
  2. Excel Compatibility
  3. Importing Data
  4. Importing Data from Excel
  5. Filtered Imports
  6. Importing from an Access Database
  7. Importing from an Access Database (Continued) and Formatting Data
  8. Creating Relationships
  9. Menu Options
  10. A Design for Life
  11. Advancing the Series
  12. Power Pivot Menu in Excel
  13. Tables, Fields and Measures
  14. Calculated Columns
  15. Introducing Measures and Aggregations
  16. Recognising Measures
  17. Measure Creation in Practice
  18. Drawing a BLANK on Error Traps
  19. Power PivotTables
  20. Introducing CALCULATE
  21. Doing More with CALCULATE
  22. Caution when Negating Formulae
  23. Introducing ALL
  24. ALLEXCEPT
  25. ALLSELECTED
  26. Power PivotTables with Multiple Tables
  27. Filters
  28. Multiple Table Management
  29. Introducing Slicers
  30. Tidying Data
  31. Calculating with Other Tables
  32. Disconnected Tables and Exchange Rates
  33. Filters Revisited
  34. Calendar Table
  35. Basic Use of Calendar Table
  36. Introducing the DATESYTD Function
  37. Introducing the TOTALYTD Function
  38. How to Refresh Data in Power Pivot
  39. Introducing the CLOSINGBALANCEMONTH Function
  40. Importance of Contiguous Dates
  41. Tips on Calculated Columns
  42. Perspectives
  43. Resource Management with Calculated Columns
  44. DAX Requirements – Fully Qualified Names
  45. DAX Syntax Requirements – Naming Conventions
  46. Introducing the DATEADD Function
  47. Introducing the IN Function
  48. Concatenating Filters
  49. How to Combine Three or More Filter Criteria into One CALCULATE Measure
  50. Lookups in Power Pivot
  51. When the CALCULATE Function Misbehaves.
  52. KEEPFILTERS to the Rescue
  53. Variables in DAX
  54. Variables and Disconnected Tables in Power BI
  55. Variables and Disconnected Tables in Power Pivot
  56. Revisiting the SUM function
  57. Introducing the SUMX function
  58. Introducing the CALCULATETABLE Function
  59. Introducing the DIVIDE Function
  60. How to Create the CAGR Measure, Part 1
  61. How to Create the CAGR Measure, Part 2
  62. How to Create the CAGR Measure, Part 3
  63. Conditional Custom Columns Using IF, AND, and ‘&&’
  64. Conditional Custom Columns Using IF, OR and ‘||’
  65. Conditional Custom Columns with Four Categories
  66. MAXX
  67. MAXX with Filter Criteria
  68. Introducing the MEDIAN Function
  69. Introducing the MEDIANX Function
  70. Introducing the SWITCH Function
  71. Introducing the NOT Function
  72. Introducing the CONCATENATE Function
  73. Introducing the SEARCH Function
  74. Grouping Text Columns with New Categories
  75. Introducing the LASTNONBLANK Function
  76. Grouping Text Columns with New Categories Dynamically using an Input Table
  77. Grouping Text Columns with New Categories Dynamically using an Input Table – Part 2
  78. Introducing the RANKX Function
  79. Dynamic Ranking based on Selection Filters
  80. Introducing the DATESINPERIOD Function
  81. Introducing the LASTDATE Function
  82. Dynamic Ranges for Rolling Averages
  83. Dynamic Ranges and Periods for Rolling Averages
  84. Highlighting Absent Students
  85. Introducing the EARLIER Function
  86. Cumulative Totals with the EARLIER Function
  87. Calculating Cumulative Totals with Variables
  88. Introducing the REPLACE Function
  89. Introducing the SUBSTITUTE Function
  90. Properly Calculating Weighted Totals with the ISFILTERED Function
  91. Power Pivot Principles : Introducing the HASONEVALUE Function
  92. Introducing the SUMMARIZE Function
  93. Power Pivot Principles : Creating a Calendar Table
  94. Introducing the SAMEPERIODLASTYEAR Function
  95. Selecting from Multiple Lookup Values
  96. Introducing the CROSSFILTER Function
  97. Understanding functions for parent-child hierarchies in DAX – Part 1
  98. Understanding Functions for Parent-Child Hierarchies in DAX – Part 2
  99. Understanding Functions for Parent-Child Hierarchies in DAX – Part 3
  100. Introducing the Function LOOKUPVALUE
  101. Understanding Functions for Parent-Child Hierarchies in DAX – Part 4
  102. Introducing the ADDCOLUMNS Function
  103. Introducing the DATESBETWEEN Function
  104. Counting Working Days
  105. Introducing the Function INTERSECT
  106. Introducing the Function DISTINCTCOUNT
  107. Introducing the Function CROSSJOIN
  108. Introducing the Function PARALLELPERIOD
  109. Bidirectional Relationships in Power Pivot
  110. Parameter Table
  111. Introducing the Function CROSSFILTER
  112. Ambiguity of Bidirectional Relationships in Power BI
  113. Using ADDCOLUMNS to Create a Calendar Table
  114. Using SELECTCOLUMNS to Create Calendar Table
  115. Using USERELATIONSHIP to Activate an Inactive Relationship
  116. Introducing the Function FIRSTNONBLANK
  117. Using DAX Studio to Return a Table Expression
  118. Finding the Top N Values in a Dataset
  119. Sorting Financial Year Months in Power Pivot
  120. Accurate Totals
  121. Duplicate Column Names
  122. Is there anything RELATED?
  123. RELATED vs LOOKUPVALUE
  124. Power Pivot Principle: Introducing the RELATEDTABLE function
  125. Introducing the DISTINCT function
  126. DISTINCT vs. DISTINCTCOUNT
  127. Introducing the VALUES Function
  128. DISTINCT vs. VALUES
  129. Introducing the PREVIOUSDAY / MONTH / QUARTER / YEAR Functions
  130. Introducing the FILTER Function
  131. The A to Z of DAX Functions – ADDCOLUMNS
  132. Introducing the FILTERS Function
  133. ISCROSSFILTERED vs ISFILTERED Functions
  134. Introducing the HASONEFILTER Function
  135. HASONEFILTER vs. HASONEVALUE vs. ISFILTERED
  136. Irregular Month-End Reporting Case – Part 1
  137. Irregular Month-End Reporting Case – Part 2
  138. Irregular Month-End Reporting Case – Part 3
  139. Irregular Month-End Reporting Case – Part 4
  140. Irregular Month-End Reporting Case – Part 5
  141. Irregular Month-End Reporting Case – Part 6
  142. SWITCH with an Expression
  143. Introducing the ALLNOBLANKROW Function
  144. Using the ALLNOBLANKROW Function to Calculate The Percentage of Total
  145. Introducing the REMOVEFILTERS Function in DAX
  146. Working with Averages – Part 1
  147. Working with Averages – Part 2
  148. Introduction to Key Performance Indicators (KPIs) in Power Pivot
  149. Using Measures to Define Target Value in KPIs
  150. Getting the Measure of a Measure – Multiple Measure Management
  151. Problems with 1 Month Ago – DATEADD vs. PREVIOUSMONTH
  152. Nothing to Draw a BLANK About – ISBLANK Zero?
  153. Size Can Be Everything
  154. Creating PivotCharts from the Power Pivot Data Model
  155. More PivotCharts from the Power Pivot Data Model
  156. SWITCH the Slicer
  157. Slicers for Columns – Part 1
  158. Slicers for Columns – Part 2
  159. Hiding Subtotals
  160. Summarising a Budget
  161. Calculating Measures
  162. Amendments Made Easily
  163. Creating a Disconnected Table for GST
  164. Sensitivity Analysis
  165. Budget vs Actuals
  166. Credit Transactions
  167. Data Cleansing
  168. Bridging the Gaps
  169. How Did I Bridge the Gaps?
  170. Slicing the Bridge
  171. Annual / Monthly Comparisons
  172. DATEADD Comparison
  173. PARALLELPERIOD Comparison
  174. PREVIOUSMONTH Comparison
  175. PREVIOUSQUARTER Comparison
  176. COGS and COGS Cash Payments
  177. Initial Measures – a Pro Tip
  178. Calculated Field vs. Measure
  179. The A to Z of DAX Functions – ABS
  180. The A to Z of DAX Functions – ACOS
  181. The A to Z of DAX Functions – ACOSH
  182. The A to Z of DAX Functions – ACOT
  183. The A to Z of DAX Functions – ACOTH
  184. The A to Z of DAX Functions – ADDMISSINGITEMS
  185. The A to Z of DAX Functions – ALL
  186. The A to Z of DAX Functions – ALLEXCEPT
  187. The A to Z of DAX Functions – ALLNOBLANKROW
  188. The A to Z of DAX Functions – ALLSELECTED
  189. The A to Z of DAX Functions – AND
  190. The A to Z of DAX Functions – ASIN
  191. The A to Z of DAX Functions – ASINH
  192. The A to Z of DAX Functions – ATAN
  193. The A to Z of DAX Functions – ATANH
  194. The A to Z of DAX Functions – AVERAGE
  195. The A to Z of DAX Functions – AVERAGEA
  196. The A to Z of DAX Functions – AVERAGEX
  197. The A to Z of DAX Functions – BETA.DIST
  198. The A to Z of DAX Functions – BETA.INV
  199. The A to Z of DAX Functions – BLANK
  200. The A to Z of DAX Functions – CALCULATE
  201. The A to Z of DAX Functions – CALCULATETABLE
  202. The A to Z of DAX Functions – CALENDAR
  203. The A to Z of DAX Functions – CALENDARAUTO
  204. Generating a List of Measure Descriptions
  205. The A to Z of DAX Functions – CEILING
  206. The A to Z of DAX Functions – CHISQ.DIST
  207. The A to Z of DAX Functions – CHISQ.DIST.RT
  208. The A to Z of DAX Functions – CHISQ.INV
  209. The A to Z of DAX Functions – CHISQ.INV.RT
  210. The A to Z of DAX Functions – CLOSINGBALANCEMONTH
  211. The A to Z of DAX Functions – CLOSINGBALANCEQUARTER
  212. The A to Z of DAX Functions – CLOSINGBALANCEYEAR
  213. The A to Z of DAX Functions – ACCRINT
  214. The A to Z of DAX Functions – ACCRINTM
  215. The A to Z of DAX Functions – ALLCROSSFILTERED
  216. The A to Z of DAX Functions – AMORDEGRC
  217. The A to Z of DAX Functions – AMORLINC
  218. The A to Z of DAX Functions – APPROXIMATEDISTINCTCOUNT
  219. The A to Z of DAX Functions – BITAND
  220. The A to Z of DAX Functions – BITLSHIFT
  221. The A to Z of DAX Functions – BITOR
  222. The A to Z of DAX Functions – BITRSHIFT
  223. The A to Z of DAX Functions – BITXOR
  224. The A to Z of DAX Functions – COALESCE
  225. The A to Z of DAX Functions – COMBIN
  226. The A to Z of DAX Functions – COMBINA
  227. The A to Z of DAX Functions – COMBINEVALUES
  228. The A to Z of DAX Functions – CONCATENATE
  229. The A to Z of DAX Functions – CONCATENATEX
  230. The A to Z of DAX Functions – CONFIDENCE.NORM
  231. The A to Z of DAX Functions – CONFIDENCE.T
  232. The A to Z of DAX Functions – CONTAINS
  233. The A to Z of DAX Functions – CONTAINSROW
  234. The A to Z of DAX Functions – CONTAINSSTRING
  235. The A to Z of DAX Functions – CONTAINSSTRINGEXACT
  236. The A to Z of DAX Functions – CONVERT
  237. The A to Z of DAX Functions – COS
  238. The A to Z of DAX Functions – COSH
  239. The A to Z of DAX Functions – COT
  240. The A to Z of DAX Functions – COTH
  241. The A to Z of DAX Functions – COUNT
  242. The A to Z of DAX Functions – COUNTA
  243. The A to Z of DAX Functions – COUNTAX
  244. The A to Z of DAX Functions – COUNTBLANK
  245. The A to Z of DAX Functions – COUNTROWS
  246. The A to Z of DAX Functions – COUNTX
  247. The A to Z of DAX Functions – COUPDAYBS
  248. The A to Z of DAX Functions – COUPDAYS
  249. The A to Z of DAX Functions – COLUMNSTATISTICS
  250. The A to Z of DAX Functions – COUPDAYSNC
  251. The A to Z of DAX Functions – COUPNCD
  252. The A to Z of DAX Functions – COUPNUM
  253. The A to Z of DAX Functions – COUPPCD
  254. The A to Z of DAX Functions – CROSSFILTER
  255. The A to Z of DAX Functions – CROSSJOIN
  256. The A to Z of DAX Functions – CUMIPMT
  257. The A to Z of DAX Functions – CUMPRINC
  258. The A to Z of DAX Functions – CURRENCY
  259. The A to Z of DAX Functions – CURRENTGROUP
  260. The A to Z of DAX Functions – CUSTOMDATA
  261. The A to Z of DAX Functions – DATATABLE
  262. The A to Z of DAX Functions – DATE
  263. The A to Z of DAX Functions – DATEADD
  264. The A to Z of DAX Functions – DATEDIFF
  265. The A to Z of DAX Functions – DATESBETWEEN
  266. The A to Z of DAX Functions – DATESINPERIOD
  267. The A to Z of DAX Functions – DATESMTD
  268. The A to Z of DAX Functions – DATESQTD
  269. The A to Z of DAX Functions – DATESYTD
  270. The A to Z of DAX Functions – DATEVALUE
  271. The A to Z of DAX Functions – DAY
  272. The A to Z of DAX Functions – DB
  273. The A to Z of DAX Functions – DDB
  274. The A to Z of DAX Functions – DEFINE
  275. The A to Z of DAX Functions – DEGREES
  276. The A to Z of DAX Functions – DETAILROWS
  277. The A to Z of DAX Functions – DISC
  278. The A to Z of DAX Functions – DISTINCT(column)
  279. The A to Z of DAX Functions – DISTINCT(table)
  280. The A to Z of DAX Functions – DISTINCTCOUNT
  281. The A to Z of DAX Functions – DISTINCTCOUNTNOBLANK
  282. The A to Z of DAX Functions – DIVIDE
  283. The A to Z of DAX Functions – DOLLARDE
  284. The A to Z of DAX Functions – DOLLARFR
  285. The A to Z of DAX Functions – DURATION
  286. The A to Z of DAX Functions – EARLIER
  287. The A to Z of DAX Functions – EARLIEST
  288. The A to Z of DAX Functions – EDATE
  289. The A to Z of DAX Functions – EFFECT
  290. The A to Z of DAX Functions – ENDOFMONTH
  291. The A to Z of DAX Functions – ENDOFQUARTER
  292. The A to Z of DAX Functions – ENDOFYEAR
  293. The A to Z of DAX Functions – EOMONTH
  294. The A to Z of DAX Functions – ERROR
  295. The A to Z of DAX Functions – EVALUATE
  296. The A to Z of DAX Functions – EVALUATEANDLOG
  297. The A to Z of DAX Functions – EVEN
  298. The A to Z of DAX Functions – EXACT
  299. The A to Z of DAX Functions – EXCEPT
  300. The A to Z of DAX Functions – EXP
  301. The A to Z of DAX Functions – EXPON.DIST
  302. The A to Z of DAX Functions – FACT
  303. The A to Z of DAX Functions – FALSE
  304. The A to Z of DAX Functions – FILTER
  305. The A to Z of DAX Functions – FILTERS
  306. The A to Z of DAX Functions – FIND
  307. The A to Z of DAX Functions – FIRSTDATE
  308. The A to Z of DAX Functions – FIRSTNONBLANK
  309. The A to Z of DAX Functions – FIRSTNONBLANKVALUE
  310. The A to Z of DAX Functions – FIXED
  311. The A to Z of DAX Functions – FLOOR
  312. The A to Z of DAX Functions – FORMAT
  313. The A to Z of DAX Functions – FV
  314. The A to Z of DAX Functions – GCD
  315. The A to Z of DAX Functions – GENERATE
  316. The A to Z of DAX Functions – GENERATEALL
  317. The A to Z of DAX Functions – GENERATESERIES
  318. The A to Z of DAX Functions – GEOMEAN
  319. The A to Z of DAX Functions – GEOMEANX
  320. The A to Z of DAX Functions – GROUPBY
  321. The A to Z of DAX Functions – HASONEFILTER
  322. The A to Z of DAX Functions – HASONEVALUE
  323. The A to Z of DAX Functions – HOUR
  324. The A to Z of DAX Functions – IF
  325. The A to Z of DAX Functions – IF.EAGER
  326. The A to Z of DAX Functions – IFERROR
  327. The A to Z of DAX Functions – IGNORE
  328. The A to Z of DAX Functions – INDEX
  329. The A to Z of DAX Functions – INFO.ALTERNATEOFDEFINITIONS
  330. The A to Z of DAX Functions – INFO.ANNOTATIONS
  331. The A to Z of DAX Functions – INFO.ATTRIBUTEHIERARCHIES
  332. The A to Z of DAX Functions – INFO.ATTRIBUTEHIERARCHYSTORAGES
  333. The A to Z of DAX Functions – INFO.CALCULATIONGROUPS
  334. The A to Z of DAX Functions – INFO.CALCULATIONITEMS
  335. The A to Z of DAX Functions – INFO.CHANGEDPROPERTIES
  336. The A to Z of DAX Functions – INFO.COLUMNPARTITIONSTORAGES
  337. The A to Z of DAX Functions – INFO.COLUMNPERMISSIONS
  338. The A to Z of DAX Functions – INFO.COLUMNS
  339. The A to Z of DAX Functions – INFO.COLUMNSTORAGES
  340. The A to Z of DAX Functions – INFO.CULTURES
  341. The A to Z of DAX Functions – INFO.CALCDEPENDENCY
  342. The A to Z of DAX Functions – INFO.DATASOURCES
  343. The A to Z of DAX Functions – INFO.DELTATABLEMETADATASTORAGES
  344. The A to Z of DAX Functions – INFO.DETAILROWSDEFINITION
  345. The A to Z of DAX Functions – INFO.DICTIONARYSTORAGES
  346. The A to Z of DAX Functions – INFO.CATALOGS
  347. The A to Z of DAX Functions – INFO.EXPRESSIONS
  348. The A to Z of DAX Functions – INFO.EXTENDEDPROPERTIES
  349. The A to Z of DAX Functions – INFO.FORMATSTRINGDEFINITIONS
  350. The A to Z of DAX Functions – INFO.FUNCTIONS
  351. The A to Z of DAX Functions – INFO.GENERALSEGMENTMAPSEGMENTMETADATASTORAGES
  352. The A to Z of DAX Functions – INFO.GROUPBYCOLUMNS

Newsletter