-
PowerPivot Introduction
-
PowerPivot Data Sources
-
Supported Data Sources
-
PowerPivot Functions
- Create a Time Table for future labs
- Use DATE Function
- Use DATEVALUE Function
- Use the DAY, MONTH, YEAR, HOUR, MINUTE, SECOND Functions
- Use EDATE Function
- Use EOMONTH Function
- Use NOW and TODAY Functions
- Use TIME and TIMEVALUE Functions
- Use WEEKDAY and WEEKNUM Functions
- Use FIRST* and LAST* Functions
- Use DATE* Functions
- Use STARTOF* and ENDOF* Functions
- Use CLOSING* and OPENING* Functions
- Use LASTOF* and FIRST* Functions
- Use PREVIOUS* and NEXT* Functions
- Use AVERAGE* Functions
- Use COUNT* Functions
- Use MAX* and MIN* Functions
- Use ALL, ALLEXCEPT and ALLNOBLANKROW
- Use CALCULATE, CALCULATETABLE
- Use DISTINCT
- Use EARLIER and EARLIEST
- Use FILTER
- Use REALTED, RELATEDTABLE
- Use VALUES
- Use Logical Functions (AND, FALSE, IF, IFERROR, NOT, OR, TRUE)
- Use Information Functions (ISBLANK, ISERROR, ISLOGICAL, ISNONTEXT, ISNUMBER, ISTEXT)
- Use TEXT Functions
-
Building Reports using PowerPivot
-
Search and Combine data Power Query
-
Explore and Visualize with Power View
-
Explore and Visualize with Power Map
0.0
0 total
5
4
3
2
1