Quizalize logo
placeholder image to represent content

How To Calculate Running Totals In Power BI Using DAX

Quiz by Nitin Gholap

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 is the purpose of creating a running total in Power BI?
    To create a static total of a metric.
    To understand how a metric is trending over time.
    To format a column with dollar signs.
    To filter a date table.
    30s
  • Q2
    How can you calculate a 30-day running total of sales in Power BI using DAX?
    By creating a separate measure for each day of the past 30 days.
    By using the FILTER function to iterate through a date table and sum the sales within the last 30 days.
    There is no DAX function for calculating running totals.
    By simply adding the sales for the last 30 days together.
    30s
  • Q3
    What is the difference between the two DAX formulas mentioned in the video for calculating a running total?
    The first formula is more complex and requires more nested logic.
    There is no difference; they achieve the same result.
    The first formula uses the FILTER function, while the second formula uses the DATEADD function.
    The second formula is less flexible and cannot be used for calculating running totals over different time periods.
    30s
  • Q4
    How can you change the time frame of a running total in the first DAX formula mentioned in the video?
    By modifying the filter function within the formula.
    By changing the number 30 in the formula to a different number, such as 90 for a 90-day running total.
    There is no way to change the time frame of a running total once the formula is created.
    You can only change the time frame by creating a new measure.
    30s
  • Q5
    How can you change the time frame of a running total in the second DAX formula mentioned in the video?
    You can only change the time frame by creating a new measure.
    By modifying the date and period arguments within the DATEADD function.
    By changing the number 30 in the formula to a different number.
    There is no way to change the time frame of a running total once the formula is created.
    30s
  • Q6
    What are some of the benefits of using running totals in Power BI?
    They can be used to filter out specific dates from your data.
    They can help you identify trends in your data over time.
    They can be used to format your data for better presentation.
    They can be used to create new calculated columns.
    30s
  • Q7
    What is one way to visualize running totals in Power BI?
    You can create a pie chart that shows the proportion of the total sales for each day in the running total.
    You can create a line chart that shows the running total over time.
    You cannot visualize running totals in Power BI.
    You can use running totals only in tables.
    30s
  • Q8
    How do running totals in Power BI adjust to additional filters applied to the report?
    Filters cannot be applied to running totals.
    You cannot create running totals for filtered data.
    The running total will only be calculated for the data that remains after the filters are applied.
    The running total will remain the same regardless of any filters applied.
    30s
  • Q9
    What are some other metrics besides sales that you could use to calculate a running total in Power BI?
    You can only calculate running totals for sales data.
    Profit, transactions, or customers.
    Running totals are not possible for any other metric.
    Dates, text, or categorical data.
    30s
  • Q10
    What resource was mentioned in the video for finding additional Power BI learning materials?
    The Microsoft documentation website.
    The Enterprise DNA website.
    There were no resources mentioned for further learning.
    A different YouTube channel.
    30s

Teachers give this quiz to your class