Other IT & SoftwareTrending Courses

Power BI DAX Practice Test and Solutions


Legend says if you cannot write DAX then you do not know Power BI.

Microsoft Power BI makes use of the scripting language Knowledge Evaluation Expressions DAX to construct customized tables, calculated columns, and measurements.

It’s a set of operators, constants, and features that may be included in a method or expression to compute and output a number of values.

On this Practice Test, you can be utilizing the Journey Works Database.

The AdventureWorks Database is the supply of data for Journey Works Cycles, a made-up worldwide manufacturing agency.

Earlier than taking this take a look at, guarantee you understand:

The Practice Test goes to cowl :

  • Aggregation Features

  • Iterator Features

  • Filter Features

  • Conditional Features

  • Logical Features

  • Date and Time Features

  • Statistical Features

  • Time Intelligence Features


  1. The hyperlink to the database will likely be given on the take a look at web page. Should you encounter any drawback downloading the database from the hyperlink, please be happy to drop me a message.

  2. You’ll load 5 tables,  from the database:

    1. Calendar Desk

    2. Prospects Desk

    3. Merchandise Desk

    4. Territories Desk

    5. Gross sales Desk

  3. Guarantee your Knowledge Modelling is true by defining the fitting relationships.

  4. Be a part of the Calendar, Prospects, Merchandise and Territories Lookup Tables to the Gross sales Knowledge Desk.

    1. Be a part of Merchandise Desk to Gross sales Desk utilizing the ProductKey Column in each Tables.

    2. Be a part of Prospects Desk to Gross sales Desk utilizing the CustomerKey Column in each Tables.

    3. Be a part of Territories Desk utilizing the  TerritoryKey Column to Gross sales Desk utilizing the SalesTerritoryKey

    4. Be a part of the Calendar Desk utilizing the Date column to the Gross sales Desk utilizing the OrderDate column

  5. Please take your time to review the database, the columns within the database are self-explanatory.

  6. Some questions might need alternative ways of fixing, offered your reply is right don’t be concerned. You may nonetheless examine with my answer.

  7. If you cannot clear up a query skip it and come again to it later.



Get Coupon

Join us on telegram for Course Updates

Join Whatsapp Group for Daily Free Courses

Leave a Reply

Your email address will not be published. Required fields are marked *