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.
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
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.