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