Conditional Logic in Calculated Columns: IF, SWITCH, ISBLANK, AND
Learn to apply conditional DAX functions such as IF, SWITCH, ISBLANK, AND, and OR to create descriptive calculated columns, enhancing data categorization and reporting in Power BI.
DAX Function
IF Power BI DAX exercises.
These concepts all use IF. Work through related PBIX exercises, compare the patterns, and submit numeric answers to save your progress.
5Related concepts
Concepts Using IF
Handle Divide-by-Zero Errors in DAX Calculated Columns
Learn how to safely divide one column by another in DAX, specifically focusing on preventing and handling divide-by-zero errors to ensure data integrity and clean reporting.
Implementing Conditional Logic with IF and SWITCH for Calculated Columns in Power BI
Create calculated columns in Power BI with DAX conditional logic, then verify the result in report visuals.
Implementing Dynamic Unit Scaling for Financial Measures with Slicers
Learn to create dynamic measures that adjust their output based on a single selection in a slicer, using `HASONEVALUE` and `VALUES` to retrieve the selected unit's divisor. Also, create a conditional title based on slicer selection.
Mastering Power BI Time Intelligence: Automatic Date Tables and DAX Functions
Learn to leverage Power BI's automatic date tables to create robust time intelligence measures using DAX functions like TOTALMTD, SAMEPERIODLASTYEAR, DATEADD, and ISINSCOPE for calculating running totals and period-over-period comparisons.