Power BI Guides

This page lists every Power BI tutorial available on Statology.

Power BI: How to Count Number of Occurrences
Power BI: How to Write an IF Statement
Power BI: How to Write an IF Statement with Multiple Conditions
Power BI: A Simple Formula for “If Contains”
Power BI: How to Replace Blanks with 0
Power BI: How to Replace Blanks with Text
Power BI: How to Convert Date to Text
Power BI: How to Convert Date to Month and Year
Power BI: How to Convert Date to Quarter and Year
Power BI: How to Convert Date to YYYYMMDD Format
Power BI: How to Get Day of Week from Date
Power BI: How to Create a Table Using DAX
Power BI: How to Create Table from Another Table Using DAX
Power BI: How to Add Index Column to Table
Power BI: How to Extract Year from Date
Power BI: How to Extract Month from Date
Power BI: How to Extract Date from Datetime
Power BI: How to Extract Hour from Datetime
Power BI: How to Extract Substring
Power BI: How to Write a Case Statement
Power BI: How to Use VLOOKUP
Power BI: How to Create a Stacked Column Chart
Power BI: Display Percentage in Stacked Column Chart
Power BI: How to Calculate Percent of Total
Power BI: How to Calculate Percent of Total by Category
Power BI: How to Calculate Percent Change
Power BI: How to Rank Values by Group
Power BI: How to Plot Multiple Lines on Line Chart
Power BI: How to Add Trend Line to Line Chart
Power BI: How to Create a Line Chart by Month
Power BI: How to Create a Line Chart by Month and Year
Power BI: How to Calculate a Cumulative Sum
Power BI: How to Calculate Cumulative Sum by Category
Power BI: How to Create a Cumulative Line Chart
Power BI: How to Remove Duplicates
Power BI: How to Remove Date Hierarchy
Power BI: How to Remove Column Headers in Table
Power BI: How to Remove Blank Rows
Power BI: How to Remove “Total” Row from Table
Power BI: How to Remove Blank Option from Slicer
Power BI: How to Remove Characters from String
Power BI: How to Remove (Blank) from Card Visualization
Power BI: How to Calculate Standard Deviation
Power BI: How to Calculate Median
Power BI: How to Calculate Average
Power BI: How to Calculate Average By Month
Power BI: How to Calculate Average and Ignore Zeros
Power BI: How to Use AVERAGE IF
Power BI: How to Use SUM IF
Power BI: How to Calculate Sum
Power BI: How to Calculate Sum with Filter
Power BI: The Difference Between SUM vs. SUMX
Power BI: How to Sum Multiple Columns
Power BI: How to Calculate Max
Power BI: How to Find Max of Multiple Columns
Power BI: How to Find Max Date
Power BI: How to Ignore Filter for a Measure
Power BI: How to Compare Two Columns
Power BI: How to Concatenate Two Columns
Power BI: How to Concatenate More Than 2 Columns
Power BI: How to Use First Row as Header
Power BI: How to Calculate a Correlation Coefficient
Power BI: How to Normalize Data Between 0 and 1
Power BI: How to Create a Pivot Table
Power BI: How to Apply Conditional Formatting to Text Column
Power BI: How to Apply Conditional Formatting to Bar Chart
Power BI: How to Apply Conditional Formatting to a Card
Power BI: How to Calculate Z-Scores
Power BI: How to Count Distinct Values in Column
Power BI: How to Count Distinct Values with Filter
Power BI: How to Get Distinct Values from Multiple Columns
Power BI: How to Create Measure with Multiple Filter Conditions
Power BI: How to Create Measure and Filter on Multiple Values
Power BI: How to Filter Between Two Dates
Power BI: How to Calculate Number of Days in Month
Power BI: How to Get First Day of Week
Power BI: How to Perform Data Binning
Power BI: How to Add Row to Table
Power BI: How to Add Column from Another Table
Power BI: How to Add Search Bar to Slicer
Power BI: How to Add Week to Date Hierarchy
Power BI: How to Add Average Line to Chart
Power BI: How to Add Days to Date
Power BI: How to Add Months to Date
Power BI: How to Show Both Value and Percentage in Bar Chart
Power BI: How to Change Column Width in Table
Power BI: How to Sort a Stacked Column Chart
Power BI: How to Only Show Top 10 Values in Chart
Power BI: How to Change Legend Order
Power BI: How to Perform Simple Linear Regression
Power BI: How to Round to 2 Decimal Places
Power BI: How to Round Time to the Nearest Hour
Power BI: How to Round Time to Nearest Quarter Hour
Power BI: How to Calculate Difference Between Two Columns in Table
Power BI: How to Calculate Days Between Two Dates
Power BI: How to Calculate Days Between Date and Today
Power BI: How to Calculate Working Days Between Two Dates
Power BI: How to Fill Blanks with Previous Value
Power BI: How to Use SUMMARIZE with FILTER
Power BI: How to Select Rows Based on Condition
Power BI: How to Use “Not Equal” Operator
Power BI: How to Use “NOT IN” Operator
Power BI: How to Perform a Left Join
Power BI: How to Perform an Inner Join
Power BI: How to Perform an Anti Join
Power BI: How to Change Order of Columns
Power BI: How to Calculate Quartiles
Power BI: How to Perform Fuzzy Matching
Power BI: How to Calculate YTD (Year to Date) Values
Power BI: How to Transpose a Table