Quizalize logo
placeholder image to represent content

YoY QoQ MoM WoW analysis

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
    What does YoY stand for?
    Quarter over Quarter
    Month over Month
    Week over Week
    Year over Year
    30s
  • Q2
    Which DAX function is used to calculate the Last Year value?
    ALL
    CALCULATE
    VAR
    SELECTEDVALUE
    30s
  • Q3
    How is the percentage change calculated in YoY?
    (Current Year Sales / Last Year Sales) - 1
    Last Year Sales - Current Year Sales
    (Current Year Sales - Last Year Sales) / Last Year Sales
    (Current Year Sales + Last Year Sales) / Last Year Sales
    30s
  • Q4
    What is the purpose of using the SELECTEDVALUE function in the LoQ (Last Quarter) calculation?
    There is no need to use SELECTEDVALUE function in LoQ calculation
    To filter the date table to the previous quarter
    To select the minimum year from the date slicer
    To compare the sales of the current quarter to the sales of all previous quarters
    30s
  • Q5
    How is the MoM (Month over Month) difference calculated?
    (Current Month Sales + Last Month Sales) / 2
    Last Month Sales / Current Month Sales
    YoY - MoM
    Current Month Sales - Last Month Sales
    30s
  • Q6
    What is the trick to identify the low sales month pattern throughout the year in the MoM analysis?
    There is no trick to identify low sales month pattern in MoM analysis
    Visually inspect the graph and identify months with low sales values
    Compare the sales of each month to the average sales of the year
    Analyze the MoM % change and identify months with negative values
    30s
  • Q7
    Which of the following statements is TRUE about WoW (Week over Week) calculation?
    It requires creating a separate measure for every week
    WoW compares the sales performance of one week to the previous week within the same year
    WoW cannot be calculated in Power BI
    It can only be applied to years with 52 weeks
    30s
  • Q8
    What is the formula used to calculate the WoW % change?
    (Current Week Sales - Last Week Sales) / Last Week Sales
    Last Week Sales / Current Week Sales
    YoY - WoW
    (Current Week Sales + Last Week Sales) / 2
    30s
  • Q9
    In the video, what was the calculated WoW % change for week 5?
    0.1388
    The video only covers YoY, QoQ, MoM calculations
    -0.176
    There is not enough information to calculate WoW % change for week 5
    30s
  • Q10
    What does the author recommend at the end of the video?
    Sharing the video with friends and colleagues
    Creating a new measure for weekly sales
    Subscribing to the taik18 channel and turning on notifications
    Downloading the Adventure Works database
    30s

Teachers give this quiz to your class