Checking Boolean conditions while creating a like for like comparison in DAX - Unplugged #36

These chapters are auto-generated

127Likes

5,628Views

2021Sep 18

This video shows how to create a like for like comparison in DAX comparing equivalent periods, and how to correctly implement a Boolean condition in a calculated column. Indeed, the presence of BLANK values in a Boolean expression might produce unexpected results. Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

Fixing “Top N and others” report when filtering by date - Unplugged #35

SQLBI

•

11K views 3 years ago

Checking Boolean conditions while creating a like for like comparison in DAX - Unplugged #36

Chapters View all

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Create temporary table

Create temporary table

Create temporary table

Add store key

Add store key

Add store key

Create measure

Create measure

Create measure

Create filter

Create filter

Create filter

Building the table

Building the table

Building the table

DAX Studio

DAX Studio

DAX Studio

SQLBI

Checking Boolean conditions while creating a like for like comparison in DAX - Unplugged #36

Comments 7

Chapters

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Create temporary table

Create temporary table

Create temporary table

Add store key

Add store key

Add store key

Create measure

Create measure

Create measure

Create filter

Create filter

Create filter

Building the table

Building the table

Building the table

DAX Studio

DAX Studio

DAX Studio

Description

Chapters View all

SQLBI

Transcript

Fixing “Top N and others” report when filtering by date - Unplugged #35

Chapters

Chapters