This helps protect our community. Learn more

Computing sales made to customers before and after a period

120K subscribers

7.2K views 2 years ago

How to manipulate the filter context to create a report with the sales made to a specific customer segment, before and after a selected month. Article and download: https://sql.bi/760164?aff=yt How to learn DAX: https://www.sqlbi.com/guides/dax/?aff=yt The definitive guide to DAX: https://www.sqlbi.com/books/the-defin...

...more

These chapters are auto-generated

Computing sales made to customers before and after a period

228Likes

7,286Views

2022Aug 16

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Computing sales made to customers before and after a period

Chapters View all

Intro

Intro

Intro

Demo

Demo

Demo

Change filters

Change filters

Change filters

Calculate statement

Calculate statement

Calculate statement

Variables

Variables

Variables

Filter period

Filter period

Filter period

Range of dates

Range of dates

Range of dates

First date of period

First date of period

First date of period

SQLBI

Computing sales made to customers before and after a period

Comments 15

Chapters

Intro

Intro

Intro

Demo

Demo

Demo

Change filters

Change filters

Change filters

Calculate statement

Calculate statement

Calculate statement

Variables

Variables

Variables

Filter period

Filter period

Filter period

Range of dates

Range of dates

Range of dates

First date of period

First date of period

First date of period

Post sales

Post sales

Post sales

Preother

Preother

Preother

Description

Chapters View all

SQLBI

Transcript

Variables in DAX

Chapters

Chapters