This helps protect our community. Learn more

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

120K subscribers

10K views 3 years ago #unplugged

Explore the differences between GENERATE and CROSSJOIN while discovering different solutions to solve a business problem described during the Guy in a Cube Q&A Live of October 9, 2021 ( • REPLAY Power BI tips from the Pros - LIVE... ). The question was how to match employees with skills at a particular level to job requirements of skills at a particular level. You can download the sample file used in the video from this page: https://www.sqlbi.com/tv/differences-... Read more about the "unplugged" format: https://www.sqlbi.com/blog/marco/2021... #unplugged

...more

These chapters are auto-generated

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

225Likes

10,140Views

2021Nov 13

Introduction

0:00

Scenario

1:40

Laura solution

4:27

Rewriting the code

8:11

Transcript

Follow along using the transcript.

SQLBI

120K subscribers

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

Chapters View all

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Laura solution

Laura solution

Laura solution

Rewriting the code

Rewriting the code

Rewriting the code

Solving the problem

Solving the problem

Solving the problem

Creating a third measure

Creating a third measure

Creating a third measure

Generator vs CrossJOIN

Generator vs CrossJOIN

Generator vs CrossJOIN

Jack Studio

Jack Studio

Jack Studio

SQLBI

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

Comments 31

Chapters

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Laura solution

Laura solution

Laura solution

Rewriting the code

Rewriting the code

Rewriting the code

Solving the problem

Solving the problem

Solving the problem

Creating a third measure

Creating a third measure

Creating a third measure

Generator vs CrossJOIN

Generator vs CrossJOIN

Generator vs CrossJOIN

Jack Studio

Jack Studio

Jack Studio

Dark Studio

Dark Studio

Dark Studio

New measure

New measure

New measure

Description

Chapters View all

Introduction

Introduction

Introduction

Scenario

Scenario

Scenario

Laura solution

Laura solution

Laura solution

Rewriting the code

Rewriting the code

Rewriting the code

SQLBI

Transcript

Using RELATED and RELATEDTABLE in DAX

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

Chapters

Chapters