Power BI 🖥️| Running Total | 3 Simple & Easy Methods | With Reset | Relative Date Slicer | Dynamic✨
In this video we will be using the real world dataset.
311 Services Requests , Little Rock ,AR USA.
👉In this video you will learn how to compute Running Total using 3 Simple Methods.
👉Additionally, you will learn how to compute running total with reset by month-year.
👉Finally you will learn about how to add Relative Date Slicer option to the Date slicer
👉 and then see the visuals change Dynamically based on the selections✨
1) We will first learn how to compute Running Total using Visual calculations.
2) Step by Step explanation of creating 2 measures and thereby understand the basic logic.
3) There are several ways you can compute "Running Total",
however the methods demonstrated in this video have been simplified.
4) Create a report page that contain interactive visuals.
Dataset: https://data.littlerock.gov/stories/s...
TIMESTAMPS
00:05 Introduction to Running Total Concept
01:13 Using Visual Calculation
04:01 Create Running Total Measure
08:36 Running Total With Reset by Month
12:30 Add a Relative Date option to the Date Slicer
14:38 Overview of the Report Page & Conclusion