| What is Power Pivot |
| How to create Power Pivot from the data model |
| How to create Power Pivot from Insert menu |
| How to insert Power Piovt from Pivot Table icon |
| A measure is a calculated field |
| DAX is the formula language that drives power pivot |
| DAX can be used to add calculated columns or to ADD measures |
| Do not use calculated columns to calculate fields for the "value" area of the pivot table, use measure |
| Calculated columns are typically placed in the filters, slicers, rows or columns areas of the pivot |
| Where to create calculated columns |
| Where to enter DAX function |
| How to add a calculated column |
How to calculate the customers age from the birthdate |
| You dont have to click on a particular cell for creating calculated columns or including columns, you can click on any cell |
| You can try excel formulae in DAX, they most probably will work but at the row level |
How to change the header of a calculated column |
| How to delete a calculated column |
| Measures are used to generate dynamic values |
| Measures don't live in the table |
| While calculated columns are based on row context, measures are based on filter context ( slicers, filters, rows and columns) |
| Use Measures when a single row can't give you the answer |
| measures can only be placed in the values area |
| Implicit measures are simply values that you drag in the value area of the pivot |
| Just Say "No" to implicit measures, explicit measures are much better |
| Creating explicit measures by using AUTOSUM |
| How to turn on and off the calculation area |
| How to create an autosum measure |
| How to rename an autosum measure |
| Don't use the Autosum measure |
| How to delete an autosum measure |
| Where to find the button for measure |
| How to add a new mesure |
| Every measure value is an island and calculates independently of the other |
| For column reference, use the fully qualified name ( i.e. Table[Column]) |
For measure reference, just use the measure name [i.e. [Measure]) |
How to create a measure of the ratio using DIVIDE |
| How to change the layout of the field list |
How to sort a field from increasing to decreasing |
How to create a measure out of COUNT, COUNTA, COUNTROWS, DISTINCTCOUNT |
How to create measure of IF, IFERROR, AND, OR |
| How to use Switch and Switch( True) |
| How to use Text Functions |
Evaluates a given expression under a set of defined filters |
| How to use CALCULATE function |
Filter() returns a table that represents a subset of another table or expression |
| Never use a filter where a normal CALCULATE function will accomplish the same thing |
| How to use Filter |
| Filtering with disconnected Slicers |
| How to add a field to a slicer |
| Syntax of ALL filter |
| How to apply ALL filter |
| Returns related values in each row of a table using relationships with other tables |
| Works just like VLOOKUP function |
| Syntax of RELATED() statement |
| This is rowwise aggregation |
| Syntax of X functions |
| How to use these functions |
| How to use RANKX function |
| Syntex of these functions |
| How to use Date and Time functions |
These allow you to calculate common time comparisons |
| Syntex of Time intelligence functions |
| How to use Time intelligence functions |
| Speed and performance considerations |
| DAX best practices |
No comments:
Post a Comment