Forum Discussion
Adding custom PI Quarters to my date table
Hello all, I'm trying to create a column in my date table that groups a range of specific, defined dates into a PI Quarter. Each PI quarter needs to start with the open date of the first sprint i...
Anonymous
You can modify your code as follows:PI Quarter = VAR FY22Q1StartDate = DATE ( 2021, 06, 30 ) VAR FY22Q1EndDate = DATE ( 2021, 10, 7 ) VAR FY22Q2StartDate = DATE ( 2021, 10, 8 ) VAR FY22Q2EndDate = DATE ( 2022, 1, 13 ) VAR _DATE = Dates[Date] RETURN SWITCH( TRUE(), _DATE >= FY22Q1StartDate && _DATE <= FY22Q1EndDate , "FY22 -Q1", _DATE >= FY22Q2StartDate && _DATE <= FY22Q2EndDate , "FY22 -Q2" )
Fowmy
Super User
Super UserAnonymous
You can modify your code as follows:
PI Quarter =
VAR FY22Q1StartDate =
DATE ( 2021, 06, 30 )
VAR FY22Q1EndDate =
DATE ( 2021, 10, 7 )
VAR FY22Q2StartDate =
DATE ( 2021, 10, 8 )
VAR FY22Q2EndDate =
DATE ( 2022, 1, 13 )
VAR _DATE = Dates[Date]
RETURN
SWITCH(
TRUE(),
_DATE >= FY22Q1StartDate && _DATE <= FY22Q1EndDate , "FY22 -Q1",
_DATE >= FY22Q2StartDate && _DATE <= FY22Q2EndDate , "FY22 -Q2"
)Thank you Fowmy ! I appreciate the assistance!