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

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: www.sqlbi.com/blog/marco/2021...
#unplugged

[@darioprskalo5569]

Thank you Alberto. Excellent explanation 👌

[@zeisslaimen1]

very enjoyable to watch. Thanks Alberto.

[@KgasS]

Thanks for showing the logical way of building the filter table to use in CALCULATE. The following code also produces the same result. The performance side is not checked.
IF(
[Sales Amount],
CALCULATE(
[Sales PY],
VALUES(Sales[StoreKey])
)
)

[@shiprasharan8298]

Hello Alberto,
Thank you for the video.
I had one small doubt.
Could you please explain why does @14:45 Column "Sales PY lkl" has different values from "Sales PY" for few of the dates after 06/05/2018
If my understanding is correct it shall display same value as " Sales PY" if we have any not null value for sales amount in current year.
Please let me know if my understanding is incorrect.
Regards,
Shipra

[@williamsantos9462]

In 14:40 when getting rid of store filter I’m not sure if the measure was computing previous year correctly. Am I wrong?

[@TheBruciaculo]

Hello Alberto,
Thank You for these series! Is Data Model / Database you use (I can see it's Contoso, but customized with e.g. more recent sales dates?) available for download anywhere? I'd love to follow along!
Keep up the amazing work!
Cheers

[@SQLBI]

We created a new version of sample databases based on Contoso as part of the training material for Mastering Tabular - the training includes several versions of the SQL database ranging from 10,000 orders to 10,000,000 orders (hundreds of GB):
www.sqlbi.com/p/mastering-tabular-video-course/
You can download the sample file used for this video here:
www.sqlbi.com/tv/checking-boolean-conditions-while-creating-a-like-fo-like-comparison-in-dax-unplugged/