# YoY QoQ MoM WoW analysis

## Quiz by Support - BusinessPromoted .com

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

Correct quiz answers unlock more play!

10 questions
• Q1
What does YoY stand for?
Year over Year
Quarter over Quarter
Week over Week
Month over Month
30s
• Q2
Which DAX function is used to calculate the Last Year value?
VAR
CALCULATE
ALL
SELECTEDVALUE
30s
• Q3
How is the percentage change calculated in YoY?
(Current Year Sales - Last Year Sales) / Last Year Sales
(Current Year Sales + Last Year Sales) / Last Year Sales
Last Year Sales - Current Year Sales
(Current Year Sales / Last Year Sales) - 1
30s
• Q4
What is the purpose of using the SELECTEDVALUE function in the LoQ (Last Quarter) calculation?
To select the minimum year from the date slicer
To filter the date table to the previous quarter
To compare the sales of the current quarter to the sales of all previous quarters
There is no need to use SELECTEDVALUE function in LoQ calculation
30s
• Q5
How is the MoM (Month over Month) difference calculated?
Current Month Sales - Last Month Sales
(Current Month Sales + Last Month Sales) / 2
Last Month Sales / Current Month Sales
YoY - MoM
30s
• Q6
What is the trick to identify the low sales month pattern throughout the year in the MoM analysis?
Analyze the graph to see if a specific month consistently has lower sales
Calculate the MoM difference for each month and see which month has the lowest value
There is no trick to identify low sales month pattern in MoM analysis
Compare the sales of each month to the average sales of the year
30s
• Q7
Which of the following is the first step to calculate WoW (Week over Week) analysis?
Create a measure to calculate the sales of the current week
Filter the data to the specific year chosen for analysis
YoY, QoQ, MoM analysis must be completed before WoW analysis
Define a variable to store the maximum week number of the year
30s
• Q8
How is the WoW (Week over Week) percentage change calculated?
YoY - WoW
Last Week Sales / Current Week Sales
(Current Week Sales + Last Week Sales) / 2
(Current Week Sales - Last Week Sales) / Last Week Sales
30s
• Q9
How is the percentage change calculated in YoY?
Last Year Sales - Current Year Sales
(Current Year Sales + Last Year Sales) / Last Year Sales
(Current Year Sales / Last Year Sales) - 1
(Current Year Sales - Last Year Sales) / Last Year Sales
30s
• Q10
Which DAX function is used to calculate the Last Year value?
SELECTEDVALUE
ALL
CALCULATE
VAR
30s

Teachers give this quiz to your class