DAX Online Test
About 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.12
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.
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
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.
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
a test remotely
Sort candidates and
get individual reports