Quizalize logo
placeholder image to represent content

Power BI DAX logical functions - IF, AND, OR, NOT, TRUE, FALSE

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    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?
    IF([Amount] > 10000, "High Value", "Normal")
    IF(OR([Amount] > 10000, [CustomerType] = "Premium"), "High Value", "Normal")
    IF([CustomerType] = "Premium", "High Value", "Normal")
    IF(AND([Amount] > 10000, [CustomerType] = "Premium"), "High Value", "Normal")
    40s
  • Q2
    You need to categorize products as "Reorder" if stock is below 50 or as "Sufficient" otherwise. Which DAX function is appropriate?
    IF([Stock] > 50, "Reorder", "Sufficient")
    IF(AND([Stock] < 50, [Stock] > 0), "Reorder", "Sufficient")
    IF([Stock] < 50, "Reorder", "Sufficient")
    IF([Stock] = 50, "Reorder", "Sufficient")
    40s
  • Q3
    How do you create a calculated column to mark "Active" if a project is ongoing (Start Date <= Today and End Date >= Today) using DAX?
    IF(AND([StartDate] <= TODAY(), [EndDate] >= TODAY()), "Active", "Inactive")
    IF(OR([StartDate] <= TODAY(), [EndDate] >= TODAY()), "Active", "Inactive")
    IF([StartDate] <= TODAY(), "Active", "Inactive")
    IF([EndDate] >= TODAY(), "Active", "Inactive")
    40s
  • Q4
    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?
    IF(AND([PurchaseCount] > 5, [LastPurchaseDate] >= TODAY()-30), "Loyal", "New")
    IF([LastPurchaseDate] >= TODAY()-30, "Loyal", "New")
    IF([PurchaseCount] > 5, "Loyal", "New")
    IF(OR([PurchaseCount] > 5, [LastPurchaseDate] >= TODAY()-30), "Loyal", "New")
    40s
  • Q5
    How would you write a DAX expression to return "True" if a value is NOT equal to 0, and "False" otherwise?
    IF([Value] = 0, TRUE(), FALSE())
    IF(NOT([Value] != 0), TRUE(), FALSE())
    IF(NOT([Value] = 0), TRUE(), FALSE())
    IF([Value] != 0, TRUE(), FALSE())
    40s
  • Q6
    In financial reporting, you need to calculate "Profit Margin" only if the "Revenue" is greater than "Cost". Which DAX function will you use?
    IF(OR([Revenue] > [Cost], [Cost] > 0), [Revenue] - [Cost], BLANK())
    IF([Revenue] >= [Cost], [Revenue] - [Cost], BLANK())
    IF([Revenue] = [Cost], [Revenue] - [Cost], BLANK())
    IF([Revenue] > [Cost], [Revenue] - [Cost], BLANK())
    40s
  • Q7
    You want to flag data as "Valid" if the "SubmissionDate" is within the current year. Which DAX formula will you use?
    IF([SubmissionDate] = TODAY(), "Valid", "Invalid")
    IF(YEAR([SubmissionDate]) = YEAR(TODAY()), "Valid", "Invalid")
    IF(MONTH([SubmissionDate]) = MONTH(TODAY()), "Valid", "Invalid")
    IF(DAY([SubmissionDate]) = DAY(TODAY()), "Valid", "Invalid")
    40s
  • Q8
    How do you write a DAX expression to return "Pass" if the score is 50 or above, otherwise "Fail"?
    IF([Score] <= 50, "Pass", "Fail")
    IF([Score] = 50, "Pass", "Fail")
    IF([Score] > 50, "Pass", "Fail")
    IF([Score] >= 50, "Pass", "Fail")
    40s
  • Q9
    For inventory management, mark items as "Overstock" if the quantity is more than 100 and "Normal" otherwise. Which DAX formula is correct?
    IF([Quantity] = 100, "Overstock", "Normal")
    IF(OR([Quantity] > 100, [Quantity] < 50), "Overstock", "Normal")
    IF([Quantity] < 100, "Overstock", "Normal")
    IF([Quantity] > 100, "Overstock", "Normal")
    40s
  • Q10
    To ensure compliance, flag records as "Compliant" if all required fields are filled. Which DAX expression will help you achieve this?
    IF(AND(NOT(ISBLANK([Field1])), NOT(ISBLANK([Field2])), NOT(ISBLANK([Field3]))), "Compliant", "Non-Compliant")
    IF(OR(ISBLANK([Field1]), ISBLANK([Field2]), ISBLANK([Field3])), "Compliant", "Non-Compliant")
    IF([Field1] = BLANK(), "Compliant", "Non-Compliant")
    IF([Field1] <> BLANK(), "Compliant", "Non-Compliant")
    40s

Teachers give this quiz to your class