Forum Discussion

mkeisha's avatar
mkeisha
Icon for Helper I rankHelper I
7 years ago
Solved

Slicer-based date range used as parameters for calculated column

My calendar table starts on 9/1/2017 and ends on 4/30/2019.  I am simply trying create a calculated column that indicates if the date is either in the BASE period or in the TEST period.  The BASE period runs from 9/1/2017 to 6/30/2018 and the TEST period runs from 7/1/2018 to 4/30/2019.  What is wrong with my calculated column because it returns TEST PERIOD for all the dates including those which are part of the base period?

 

=if(('Calendar'[Date] >= 9/1/2017 && 'Calendar'[Date] <= 6/30/2018), "Base Period", "Test Period")

 

Thank you.  

  • Hi mkeisha,

    Try the following formula:
    Colum =
    IF (
    (
    'Calendar'[Date] >= DATE ( 2017, 9, 1 )
    && 'Calendar'[Date] <= DATE ( 2018, 6, 30 )
    ),
    "Base Period",
    "Test Period"
    )

    Regards,
    MFelix

3 Replies

  • Hello,

     

    You can try this:

    =if(('Calendar'[Date] >= DATEVALUE("9/1/2017") && 'Calendar'[Date] <= DATEVALUE("6/30/2018")), "Base Period", "Test Period")

    Regards,

    ElenaN

  • Hi mkeisha,

    Try the following formula:
    Colum =
    IF (
    (
    'Calendar'[Date] >= DATE ( 2017, 9, 1 )
    && 'Calendar'[Date] <= DATE ( 2018, 6, 30 )
    ),
    "Base Period",
    "Test Period"
    )

    Regards,
    MFelix