Forum Discussion
Flag column
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
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
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.
2 Replies
Create this one as a column.
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.
