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.


Insert your email address and press Download for access to the files used in this video.

Keep me informed about BI news and upcoming articles with a bi-weekly newsletter (uncheck if you prefer to proceed without signing up for the newsletter)

Send me SQLBI promotions (only 1 or 2 emails per year)

By downloading the file(s) you are agreeing to our Privacy Policy and accepting our use of cookies.