Grow your YouTube views, likes and subscribers for free

Get Free YouTube Subscribers, Views and Likes

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

Follow

SQLBI

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

posted by Reitanitb

Differences between GENERATE and CROSSJOIN solving business scenarios Unplugged #37

Differences between GENERATE and CROSSJOIN solving business scenarios Unplugged #37

Choosing between Date or Integer to represent dates in Power BI and Tabular

Choosing between Date or Integer to represent dates in Power BI and Tabular

Ep. 12: In Conversation with Nevada’s 2024 Teacher of the Year, Laura Jeanne Penrod

Ep. 12: In Conversation with Nevada’s 2024 Teacher of the Year, Laura Jeanne Penrod

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

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

Implementing running total from arbitrary dates in DAX Unplugged #34

Implementing running total from arbitrary dates in DAX Unplugged #34

Best Way to Perform LikeforLike Comparison in Power BI

Best Way to Perform LikeforLike Comparison in Power BI

Optimizing callbacks in a SUMX iterator

Optimizing callbacks in a SUMX iterator

Headerdetail vs star schema models in Tabular and Power BI

Headerdetail vs star schema models in Tabular and Power BI

Different options to model many to many relationships in Power BI and Tabular

Different options to model many to many relationships in Power BI and Tabular

Comment review: Answering a question about TOPN cross filtering Unplugged #16

Comment review: Answering a question about TOPN cross filtering Unplugged #16

[DAX] Best Practices 101 for Optimization & Performance (with Alberto Ferrari)

[DAX] Best Practices 101 for Optimization & Performance (with Alberto Ferrari)

DAX by examples

DAX by examples

When to use KEEPFILTERS over iterators

When to use KEEPFILTERS over iterators

Using ALLEXCEPT vs ALL VALUES

Using ALLEXCEPT vs ALL VALUES

Building SVG Charts in Power BI

Building SVG Charts in Power BI

Adding working days to a date in DAX calculated column Unplugged #30

Adding working days to a date in DAX calculated column Unplugged #30

Differences between ALLSELECTED and KEEPFILTERS Unplugged #33

Differences between ALLSELECTED and KEEPFILTERS Unplugged #33

How to use Power BI DAX Tutorial

How to use Power BI DAX Tutorial

Use DAX to Show Values in any Way You Like! Dynamic Format Strings in Power BI

Use DAX to Show Values in any Way You Like! Dynamic Format Strings in Power BI

Optimizing conditions involving blank values in DAX

Optimizing conditions involving blank values in DAX

Recommended

5 Shirt Hacks Every Man Should Know

5 Shirt Hacks Every Man Should Know

01:25

Office Pranks & Where To Find Them

Office Pranks & Where To Find Them

10:02

Almost Every Mom's Morning

Almost Every Mom's Morning

04:08

Take Any Fruits But No Pomergranates, Please

Take Any Fruits But No Pomergranates, Please

00:29

How To Find A Boyfriend In 5 Seconds

How To Find A Boyfriend In 5 Seconds

01:38

I Can Do Better Prank Compilation

I Can Do Better Prank Compilation

13:57

The Longest Video On Doovi Ever Posted!

The Longest Video On Doovi Ever Posted!

08:48:53

How To Cook LEGO Gummy Sweet!

How To Cook LEGO Gummy Sweet!

06:19