Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 Th...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    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.

     

v-frfei-msft's avatar
v-frfei-msft
Community Support
6 years ago

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.