Write DAX without Power BI Desktop

DAX Interview Practice for Power BI Developers

Most DAX tutorials show you a formula. Interviews ask you to write one. Practise on a real star schema, write your measure or query in the browser and see straight away whether it returns what Power BI Desktop would.

  • Free to start
  • Runs in your browser
  • Nothing to install
DAX questions
40
checked in Power BI
100%
and Windows
Mac
Who it's for

Built for the way you work

The situations people open the DAX Interview Practice for, most often.

Job seekers01

Prepare for the DAX round

Work through the kind of DAX questions analyst interviews actually ask, and see straight away whether your answer is right.

Students02

Practise without a setup

No database, licence or install to sort out first. Open the page on any laptop and start answering.

Working analysts03

Keep your skills sharp

Ten minutes on a few Medium or Hard questions is a quick way to stay fluent between projects.

What you get

Measures, CALCULATE and time intelligence on a star schema, checked against Power BI.

The topics interviews test

CALCULATE, filter and row context, iterators, ALL and REMOVEFILTERS, and time intelligence.

No Power BI needed

Write and run DAX in the browser on any computer, including Mac.

Answers checked against Power BI

Every question’s expected result was verified in Power BI Desktop.

Star schema data

Fact and dimension tables joined by relationships, like a real model.

How it works

Start practising in 3 steps

The DAX Interview Practice, step by step
Before you start

Safe to try. Easy to trust.

Free to start

No card needed. Upgrade only for the extras listed under Plans.

Runs in your browser

Nothing to install and nothing to configure. Open the page and start.

Windows and Mac

Works on any laptop with a modern browser, at work or at home.

Answers checked instantly

Every answer is compared with the expected result the moment you run it.

Plans

Start free. Pay only for the extras.

Use the DAX Interview Practice for free. Upgrade only for the parts below.

Free

No card needed
  • Every Easy and Medium question
  • Hints and the free playground
  • Leaderboard and badges when signed in
Start free

Lifetime

Most popular

Billed yearly

  • Hard questions
  • Worked solutions for every question
Get Lifetime

Pro

Billed monthly
  • Everything in Lifetime
See Pro price
Guide

How DAX interview questions are usually asked

Expect questions like total sales for last year, sales for one category regardless of the slicer, running totals, percent of total and the difference between SUM and SUMX. They test whether you understand filter context, not whether you remember function names.

CALCULATE is at the centre of almost all of them. If you can explain what filters it adds or removes, and when row context becomes filter context, you can answer most DAX interview questions.

The engine here is the open-source dax-sql compiler, which turns DAX into SQL. It is not Microsoft’s engine, so free-form queries can occasionally differ, but the questions themselves were checked against Power BI Desktop.

FAQ

Questions people ask first

Something else? Write to us.

Do I need Power BI Desktop installed?

No. Everything runs in your browser, so it works on Mac and on computers where you cannot install software.

Is this the real DAX engine?

No, it uses an open-source compiler. The questions were verified against Power BI Desktop, but unusual free-form queries can sometimes give a different result.

Is it free?

Easy and Medium questions are free, with no signup. Hard questions and worked solutions come with Lifetime or Pro.

Try the DAX Interview Practice now

Measures, CALCULATE and time intelligence on a star schema, checked against Power BI.

More free tools

See all tools
Practice

Joins, group by and window functions on six connected tables. Runs in your browser.

Start SQL practiceHow it works
Practice

Lookups, SUMIFS and dynamic arrays in a real spreadsheet, checked against Excel.

Start Excel practiceHow it works
Practice

Core Python and pandas questions running on real Python in your browser.

Start Python practiceHow it works