Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

New Column using IF and DATESBETWEEN causing Error

I'm trying to create a set of columns that show either the date or null value based off an IF and DATESBETWEEN calculation.   Essentially, I need to create a column for each year that is respresented...
Need Help
Tips and Tricks
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Anonymous,

     

    Just use DAX below.

    Column =
IF ( YEAR ( 'Case'[a_CreatedDateOnly] ) = 2018, 'Case'[a_CreatedDateOnly] )
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
8 years ago

Anonymous,

 

Just use DAX below.

Column =
IF ( YEAR ( 'Case'[a_CreatedDateOnly] ) = 2018, 'Case'[a_CreatedDateOnly] )
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thank you Sam!  I guess I tried to make it way too complex.  This worked perfectly.