Home / Learn / Courses / Power BI and DAX / Playground
All lessons

DAX playground

Write measures, calculated columns or EVALUATE queries on the Northbay Goods model and run them with Ctrl+Enter. Pick a column to split the result by, like a table visual in Power BI. Click a row of the result, then "Show me what happened" to see the steps.

DAX playground

Write a measure and press Run.

Functions this editor knows (113)

ABS, ADDCOLUMNS, ALL, ALLEXCEPT, ALLNOBLANKROW, ALLSELECTED, AND, AVERAGE, AVERAGEX, BLANK, CALCULATE, CALCULATETABLE, CALENDAR, CALENDARAUTO, COALESCE, CONCATENATE, CONCATENATEX, CONTAINSSTRING, COUNT, COUNTA, COUNTAX, COUNTBLANK, COUNTROWS, COUNTX, CROSSFILTER, CROSSJOIN, DATE, DATEADD, DATEDIFF, DATESBETWEEN, DATESINPERIOD, DATESMTD, DATESQTD, DATESYTD, DAY, DISTINCT, DISTINCTCOUNT, DIVIDE, EDATE, ENDOFMONTH, ENDOFYEAR, EOMONTH, FALSE, FILTER, FIRSTDATE, FORMAT, GENERATESERIES, HASONEVALUE, IF, IF.EAGER, IFERROR, INT, ISBLANK, ISCROSSFILTERED, ISFILTERED, ISINSCOPE, KEEPFILTERS, LASTDATE, LEFT, LEN, LOOKUPVALUE, LOWER, MAX, MAXX, MIN, MINX, MOD, MONTH, NEXTMONTH, NEXTYEAR, NOT, OR, PARALLELPERIOD, POWER, PREVIOUSMONTH, PREVIOUSQUARTER, PREVIOUSYEAR, PRODUCTX, QUARTER, RANKX, RELATED, RELATEDTABLE, REMOVEFILTERS, RIGHT, ROUND, ROUNDDOWN, ROUNDUP, ROW, SAMEPERIODLASTYEAR, SELECTCOLUMNS, SELECTEDVALUE, SQRT, STARTOFMONTH, STARTOFYEAR, SUM, SUMMARIZE, SUMMARIZECOLUMNS, SUMX, SWITCH, TODAY, TOPN, TOTALMTD, TOTALQTD, TOTALYTD, TREATAS, TRUE, UNION, UPPER, USERELATIONSHIP, VALUE, VALUES, WEEKDAY, YEAR

The model

The Northbay Goods model Product ProductKey 🔑ProductCategoryUnitPriceUnitCost Store StoreKey 🔑StoreCityRegionOpenDate Sales (fact) OrderLineDateStoreKeyProductKeyQuantityUnitPriceUnitCostAmount Date Date 🔑YearQuarterMonthNoMonthYearMonthDayWeekday Targets YearMonthStoreKeyTarget 1*1*1*1* Arrows: the way filters flow (one side → many side). 🔑 key column. fibub.com
Each Sales row is one order line. Product, Store and Date describe it. A filter on Product[Category] flows along the arrow to Sales, so a measure on Sales sees only that category. Targets are monthly per store, so they relate to Store but not to the daily Date table (Lesson 6.4 shows how to bring them together).

This is a teaching engine that follows the documented DAX rules, not Microsoft's own engine: it covers the functions used in the course (see the list under the editor). Relationships are single direction, many to one. Everything runs in your browser; nothing you type is sent or saved.