Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.
Give this quiz to my class
Q 1/10
Score 0
In a sales dashboard, you need to flag orders as "High Value" if the amount exceeds $10,000 and the customer is "Premium". Which DAX formula will you use?
In a sales dashboard, you need to flag orders as "High Value" if the amount exceeds $10,000 and the customer is "Premium". Which DAX formula will you use?
1
40 sec
Q.
You need to categorize products as "Reorder" if stock is below 50 or as "Sufficient" otherwise. Which DAX function is appropriate?
2
40 sec
Q.
How do you create a calculated column to mark "Active" if a project is ongoing (Start Date <= Today and End Date >= Today) using DAX?
3
40 sec
Q.
For a customer loyalty program, flag customers as "Loyal" if they have made more than 5 purchases and the last purchase was within 30 days. Which DAX formula is correct?
4
40 sec
Q.
How would you write a DAX expression to return "True" if a value is NOT equal to 0, and "False" otherwise?
5
40 sec
Q.
In financial reporting, you need to calculate "Profit Margin" only if the "Revenue" is greater than "Cost". Which DAX function will you use?
6
40 sec
Q.
You want to flag data as "Valid" if the "SubmissionDate" is within the current year. Which DAX formula will you use?
7
40 sec
Q.
How do you write a DAX expression to return "Pass" if the score is 50 or above, otherwise "Fail"?
8
40 sec
Q.
For inventory management, mark items as "Overstock" if the quantity is more than 100 and "Normal" otherwise. Which DAX formula is correct?
9
40 sec
Q.
To ensure compliance, flag records as "Compliant" if all required fields are filled. Which DAX expression will help you achieve this?
