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
353. The A to Z of DAX Functions – INFO.HIERARCHIES
354. The A to Z of DAX Functions – INFO.HIERARCHYSTORAGES
355. The A to Z of DAX Functions – INFO.KPIS
356. The A to Z of DAX Functions – INFO.LEVELS
357. The A to Z of DAX Functions – INFO.LINGUISTICMETADATA
358. The A to Z of DAX Functions – INFO.MEASURES
359. The A to Z of DAX Functions – INFO.MODEL
360. The A to Z of DAX Functions – INFO.OBJECTTRANSLATIONS
361. The A to Z of DAX Functions – INFO.PARQUETFILESTORAGES
362. The A to Z of DAX Functions – INFO.PARTITIONS