Forum Discussion

ajay_gajree's avatar
ajay_gajree
Helper I
6 years ago
Solved

Dates Between Flag

Hi I am trying to create a Flag Column to tag a date column as 1 or 0 depending if it falls between 2 dates I have tried DateFlag = IF( DATESBETWEEN( Data [Date], DATE(2020,01,15), DATE(2...
Need Help
  • v-gizhi-msft's avatar
    v-gizhi-msft
    6 years ago

    Hi,

     

    For your issue, it is because DATESBETWEEN returns a range of date but not a single value.

    So please try this calculated column:

    Column = IF('Table'[Date] in DATESBETWEEN('Table'[Date],DATE(2020,1,15),DATE(2020,2,14)),1,0)

    The result shows:

    Hope this helps.

     

    Best Regards,

    Giotto Zhi

     

vanessafvg's avatar
vanessafvg
Community Champion
6 years ago

ajay_gajree  are you sure you creating a column and not a measure?  a measure wants an aggregation.