- About Power BI:
- Power BI License
- Power BI Installation
- Power Query:
- Way to go Power Query
- ETL
- Connections
- Transformations
- Data type changes
- Replace values
- Duplicate
- Reference
- Append Queries
- Merge Queries
- Joins
- Text Functions
- Merge Columns
- Date functions
- Number Functions
- Transform Data
- Add column
- 1st Process
- 2nd Process
- Column from example
- Conditional Column
- Custom Column
- M- Language
- Power Pivot:
- Modeling
- What is Fact table
- What is Dimension table
- Star Schema
- Snow Flake Schema
- Cardinality
- Cross Filtering
- Why we have to create relationship
- Create Relationship with auto detect
- Create Relationship Manually
- Edit Relationship
- Configure additional options
- Cross Filter direction
- Relationship type
- Row level security
- Calendar
- Calendar Auto
- DAX:
- What is DAX
- New measure/Calculated measure
- New Column/Calculated Column
- Syntax
- DAX operators
- Types of operators
- Arithmetic operators
- Logical operators
- Text operators
- Date and time functions
- Count
- SUM
- SUMX
- Filter Functions:
- Calculate
- Calculate Table
- Filter
- All
- All Except
- All selected
- Lookup Value
- Remove Filter
- Keep Filter
- Logical Functions:
- If
- Switch
- AND
- OR
- Coalesce
- Text Functions:
- Left
- Right
- Mid
- Trim
- Find
- Search
- Upper
- Lower
- Time Intelligence Functions
- Total MTD
- Total QTD
- Total YDT
- Total YTD
- Date add
- Same Period last year
- Relationship Functions:
- Related
- Related table
- User Relationship
- Parent-Child Relationship
- Path
- Path contain
- MAXX/Userprince name
- Table Manipulation Functions:
- Calendar
- Calendar Auto
- Calculate table
- Filter
- Union
- Summarize
- Count
- Countx
- CountA
- CountAX
- CountDistinct
- CountBlanks
- Power View:
- Reporting
- How to delete Page
- How to Rename Page
- How to Duplicate Page
- Visualization Pane
- Table
- Table Basic Formatting
- Table Conditional Formatting
- Table Aggregations
- Matrix
- Matrix Basic Formatting
- Matrix Conditional Formatting
- Matrix Hierarchies
- Sub Total and Total
- Card
- Multi Row Card
- Filters:
- Visual Level Filter
- Page Level Filter
- Report Level Filter
- Drill Through Filter
- Bar charts
- Line Chart
- Area Chart
- Ribbon Chart
- Map
- Gauge
- Slicer:
- Text Slicer
- Date Slicer
- Number Slicer
- Sync Slicer
- Value Pane
- Field Pane
- Format Pane
- Buttons
- Images
- Shapes
- Text
Power BI Index
Power BI Community Force
March 22, 2021