Answering questions: running total and last dates within selection - Unplugged #38

These chapters are auto-generated

185Likes

7,358Views

2021Dec 4

How to apply a running total and a filter by using the last dates within the selection to the visualization explained in the article Show previous 6 months of data from single slicer selection (https://www.sqlbi.com/articles/show-p.... The video shows the process of exploring a solution while replying to questions received in the article comments. Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Differences between GENERATE and CROSSJOIN solving business scenarios - Unplugged #37

SQLBI

•

10K views 3 years ago

Answering questions: running total and last dates within selection - Unplugged #38

Chapters View all

Introduction

Introduction

Introduction

Recap

Recap

Recap

Code

Code

Code

Results

Results

Results

Last 3 months

Last 3 months

Last 3 months

Last 6 months

Last 6 months

Last 6 months

Last date with sales

Last date with sales

Last date with sales

Testing

Testing

Testing

SQLBI

Answering questions: running total and last dates within selection - Unplugged #38

Comments 15

Chapters

Introduction

Introduction

Introduction

Recap

Recap

Recap

Code

Code

Code

Results

Results

Results

Last 3 months

Last 3 months

Last 3 months

Last 6 months

Last 6 months

Last 6 months

Last date with sales

Last date with sales

Last date with sales

Testing

Testing

Testing

Description

Chapters View all

SQLBI

Transcript

Differences between GENERATE and CROSSJOIN solving business scenarios - Unplugged #37

Chapters

Chapters