DAX Online Test
For Jobseekers
Practice your skills and earn a certificate of achievement when you score in the top 25%.
Take a Practice TestFor Companies
Test candidates with real-world problems and interview the best ones.
Sign Up to Offer this TestAbout the test
The DAX online test assesses knowledge of using DAX for Power BI reports.
The assessment includes work-sample tasks such as:
- Creating Power BI reports using DAX.
- Using proper DAX formulas.
- Using measures to calculate results from DAX formulas.
A good Power BI developer needs to be able to write DAX expressions, create calculated columns, measures, and custom tables from data that is already in the model.
Sample public questions
A Power BI report has a measure declared as:
Profit percentage = SUM(financials[Profit]) / CALCULATE(SUM(financials[Profit]), ALL(financials))Select all the true statements if the "Profit percentage" is used as a value in a bar chart where Country is the axis.
A business owner needs a Power BI report which shows the projected quantity for each item. The "quantity" column is in the "items" table.
Fill in the blank of the following DAX expression for a new column that will compute the projected quantity, which is the current quantity plus 12%:
Projected Quantity = ______________ * 1.12For jobseekers: get certified
Earn a free certificate by achieving top 25% on the DAX test with public questions.
Take a Certification TestSample silver certificate
Sunshine Caprio
Java and SQL TestDomeCertificate
For companies: premium questions
Buy TestDome to access premium questions that can't be practiced.
Get money back if you find any premium question answered online.
Ready to Interview?
Use these and other questions from our library with our
Code Interview Platform.
13 more premium DAX questions
Query Join, Sale Discount, Modifying Profit, Profit Chart, Average Sales, Regional Report, Net Adds, Grocery Sales, Sales per Product, Beverage Sales, Book Sales, Device Purchases, Marketing Performance Report.
Skills and topics tested
- Power BI
- Power Query
- DAX
- Chart Configuration
- Drilldown
- Slicer
- Data Cleaning
- Data Aggregation
- Matrix Visualization
- Data Modeling
- Performance Tuning
- Bug Fixing
- Row-Level Security
For job roles
- Data Analyst
- Power BI Analyst
- Power BI Developer
Sample candidate report
Need it fast? AI-crafted tests for your job role
TestDome generates custom tests tailored to the specific skills you need for your job role.
Sign up now to try it out and see how AI can streamline your hiring process!
What others say
Simple, straight-forward technical testing
TestDome is simple, provides a reasonable (though not extensive) battery of tests to choose from, and doesn't take the candidate an inordinate amount of time. It also simulates working pressure with the time limits.
Jan Opperman, Grindrod Bank
Product reviews
Used by
Solve all your skill testing needs
150+ Pre-made tests
From web development and database administration to project management and customer support. See all pre-made tests.
130+ skills
From JavaScript and SQL to English and customer support. See all questions to filter by skill.
Multi-skills Test
Mix questions for different skills or even custom questions in one test. See an example.
How TestDome works
Choose a pre-made test
or create a custom test
Invite candidates via
email, URL, or your ATS
Candidates take
a test remotely
Sort candidates and
get individual reports
