IF Statement with 2 unrelated columns

[simonliucan]

Hi there,

I have a fact table joined with time table (timekey, many-to-one) and product table (productkey, many-to-one).

I want to create a flag with following logic but unsuccessful:

Flag = IF(product.sku = "xxxxxxxx" && time.date >= "mm/dd/yyyy", "N", "Y")

Is there any way I can use DAX functions to achieve this without changing the dataset?

Thanks,

[kentyler]

are you trying to do this with a measure or with a calculated column ?

[simonliucan]

Calculated column