Power BI DAX

Power BI DAX Examples

Power BI DAX examples for KPI measures, reporting formulas, time intelligence, and dashboard calculations.

💡 Ideas for You

Resources for moving spreadsheet-style calculations into dashboards.

4 useful links
📚 Step-by-step booksStart with beginner-friendly step-by-step books and learning resources from Create & Learn.📉 Power BI DAX guidesBooks and references for measures, model logic, and reporting formulas.📊 Dashboard reporting booksResources for creating clearer dashboards and report layouts.📘 Data modeling resourcesHelpful material for relationships, measures, and model structure.

Power BI DAX Examples

Power BI DAX examples for KPI measures, reporting formulas, time intelligence, and dashboard calculations.

Choose a page below for the full explanation, examples, steps, and related tips.

CALCULATE function in Power BI DAXSUMX function in Power BI DAXAVERAGEX function in Power BI DAXCOUNTROWS function in Power BI DAXDISTINCTCOUNT function in Power BI DAXDIVIDE function in Power BI DAXFILTER function in Power BI DAXALL function in Power BI DAXALLSELECTED function in Power BI DAXALLEXCEPT function in Power BI DAXVALUES function in Power BI DAXSELECTEDVALUE function in Power BI DAXRELATED function in Power BI DAXRELATEDTABLE function in Power BI DAXSWITCH function in DAX in Power BI DAXIF function in DAX in Power BI DAXVAR and RETURN in DAX in Power BI DAXTotal Sales measure in Power BI DAXTotal Cost measure in Power BI DAXGross Margin measure in Power BI DAXGross Margin Percent measure in Power BI DAXAverage Order Value measure in Power BI DAXCustomer Count measure in Power BI DAXOrders measure in Power BI DAXUnits Sold measure in Power BI DAXConversion Rate measure in Power BI DAXChurn Rate measure in Power BI DAXRetention Rate measure in Power BI DAXCAC measure in Power BI DAXROAS measure in Power BI DAXLTV measure in Power BI DAXRevenue per Employee measure in Power BI DAXInventory Turnover measure in Power BI DAXYTD Sales measure in Power BI DAXMTD Sales measure in Power BI DAXQTD Sales measure in Power BI DAXPrevious Month Sales measure in Power BI DAXPrevious Year Sales measure in Power BI DAXYear over Year Growth measure in Power BI DAXMonth over Month Growth measure in Power BI DAXRolling 3 Month Sales measure in Power BI DAXRolling 12 Month Sales measure in Power BI DAXRunning Total measure in Power BI DAXDATEADD function in Power BI DAXDATESYTD function in Power BI DAXSAMEPERIODLASTYEAR function in Power BI DAXPARALLELPERIOD function in Power BI DAXDATESINPERIOD function in Power BI DAXDAX ranking measure in Power BI DAXDAX percent of total measure in Power BI DAXDAX dynamic title measure in Power BI DAXDAX conditional formatting measure in Power BI DAXDAX target status measure in Power BI DAXDAX top N measure in Power BI DAXDAX customer segmentation measure in Power BI DAXDAX active customers measure in Power BI DAXDAX new customers measure in Power BI DAXDAX repeat customers measure in Power BI DAX