Power BI DAX Practice

Practice DAX Online

{{ totalCount }} questions · {{ shHardPct }}% Hard. Scenario-based DAX measures on a Sales star-schema model. Write a measure, compare your visual with the expected result in the live simulator, then submit against hidden filter tests.

Questions

Topics

Solved

Acceptance

Bookmark Question Topic Difficulty Status

{{ r.n }} - {{ r.title }}{{ r.badge }}{{ r.lock }} {{ r.topic }} {{ r.difficulty }} {{ r.statusIcon }}

No questions match these filters.

Showing {{ shRange }} of {{ shFilteredCount }}

Guests can solve {{ freeLimit }} problems for free. Log in or sign up (free) to unlock everything, keep your streak and appear on the leaderboard. New to a topic? Learn it first in the Power BI course.

Your Progress

Reset all progress on this practice page{{ shResetScope }}? This can't be undone.

{{ pr.label }} ({{ pr.pct }}%){{ pr.solved }}/{{ pr.total }}

Points: {{ shMyPoints }} · Easy 10 · Medium 20 · Hard 40

Daily challenge

{{ daily.title }} · {{ daily.difficulty }}

🔥 Longest streak: {{ shStreak.longest }}Current streak: {{ shStreak.current }}

Leaderboard (rolling 100 days)

Loading…

{{ u.rank }} {{ u.name }}{{ u.points }} pts

{{ q.num }}. {{ q.title }} {{ q.difficulty }} {{ q.topic }} {{ q.solvedLabel }} Simulated – not Power BI

{{ shPointsLabel }} ⏱ {{ shTimer }}

Data model

Star schema · click a table

OrderDate (active) · ShipDate (dashed, inactive)

Every relationship is one-to-many (1 → *) and filters flow from the dimension to Sales. 'Date' is marked as a date table.

{{ preview.title }} {{ preview.count }} rows · first 6 shown

            
              {{ pc.name }}

              {{ cv }}

{{ pc.name }}
{{ cv }}

Base measures

Hidden for this question — build the logic from columns.

Task: {{ q.task }}

Measure name: [{{ q.measure }}] · Visual: {{ q.visualLabel }}

Target visual — expected result {{ slicerSummary }}

{{ tv.firstLabel }}max {{ tv.maxTxt }}{{ tv.lastLabel }}

{{ tv.rowHeader }}	{{ q.measure }}
{{ b.label }}	{{ b.expTxt }}

{{ tv.rowHeader }}	{{ ch }}
{{ mr.label }}	{{ mc.exp }}

DAX editor Suggestions from the model as you type · Ctrl/⌘ + Enter to run

— {{ sig.desc }}

⚠ Schema check: {{ lw }}

{{ errorText }}

Learn the concept first: {{ q.topic }} in the Power BI course

Your submissions (last 20, saved on this device)

No submissions yet. Press Submit to judge your code against all tests.

🔒 Solution locked

The model solution and step-by-step explanation unlock when you solve this problem or after 3 unsuccessful submissions ({{ shFailsLabel }}). Struggling? Try the hints on the Question tab first.

{{ q.solution }}

How it works — step by step

Live output

Simulated – not Power BI

Year Region Category

Run your measure to draw it here next to the expected result. Change the slicers to test it under different filters.

{{ runErrorText }}

{{ out.summary }} Expected Yours

Expected

Yours

{{ out.rowHeader }}	{{ ch }}
{{ mr.label }}	{{ mc.yours }}

Green cells match the expected value, red cells differ (hover a cell for the expected value).

{{ out.rowHeader }}	Expected	Yours
{{ b.label }}	{{ b.expTxt }}	{{ b.yourTxt }}	{{ b.mark }}

Rows where both values are blank are hidden, as in Power BI. Blank and 0 are treated as equal when checking. Submit also tests 7 hidden slicer combinations.