Flag column

[Anonymous]

Hello again
Trying to write a Dax to generate a conditional column or measure. I have multiple date columns and it has to show 0 when one date field is later than other or one date field is blank
The bottom one is giving me 0 in flag column when the hire date and release date even same.
Any thing I am missing to add?
If([release date]=BlANK()||[release date>[hire date],1,0)
Thanks

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Please create a calculated column as bleow.

Column = IF('Table'[release date] = BLANK() || 'Table'[release date]>'Table'[Hire date],0,1)

 

Pbix as attached.

[amitchandak]

Create this one as a column.