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 per...
Need Help
  • MFelix's avatar
    MFelix
    7 years ago
    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
MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago
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
mkeisha's avatar
mkeisha
Icon for Helper I rankHelper I
7 years ago

Thank you, works perfectly!