DAX If Date is Greater than Date then 0 else 1

[DebbieE]

I tried creating the following DAX Column

Max OMS Date Flag = IF('dim Date'[date].[Date]'>=[MAX Date],0,1)

Because I want to use this as a filter for a visual but I get the expression refers to multiple columns. Multiple columns cannot be converted to a scalar value

I clearly need to change this DAX query because I cant say where the date in the dim table is greater than or equal to my max date but Im not sure how

[parry2k]

@DebbieE what you are trying to achieve? Your question is not fully clear.

[DebbieE]

I tried creating the following DAX Column

Max OMS Date Flag = IF('dim Date'[date].[Date]'>=[MAX Date],0,1)

Because I want to use this as a filter for a visual but I get the expression refers to multiple columns. Multiple columns cannot be converted to a scalar value

I think the above is fairly clear

I clearly need to change this DAX query because I cant say where the date in the dim table is greater than or equal to my max date but Im not sure how

I need A DaX Query  to set the flag. If my date is greater than the max date in another table set to 0 else set to 1

[AnthonyTilley · Accepted solution]

Create a calculated colunm and use the following dax changing the table and colunm names to your own 

checkdate =

--get the maxdate from table2

Var d2 = max(Table2[DATE])

var ret = if(Table1[Date] >= d2, 0,1)

return ret