Fact table, two date column -> DAX show only data where YEAR(date1) = YEAR(date2)

[FatherTheWizard]

Hi

I have sales data which has two date columns (let's call them date1 and date2). I would like to only show data where the year of these columns match -> example: if date1 = 1.12.2019 and date2 = 1.1.2020 -> exclude row.

Can you help me finalize this?

[Greg_Deckler · Accepted solution]

IF(YEAR([Date1]) = YEAR([Date2]),1,BLANK())