Forum Discussion

Gillard_2's avatar
Gillard_2
Frequent Visitor
7 years ago
Solved

Create Period Column

I currently have a date table with dates for the next five years.

I would like to create a new Period Column that is 13 four week periods starting on a specified date?

Thanks in advance

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Gillard_2 

    You may create a rank column and use IF condition to get the column.If it is not your case,please share more details for us so that we could help further on it.For example:

    Rank = RANKX('Date','Date'[Date],,ASC)
    Column = IF('Date'[Rank]>=5&&'Date'[Rank]<=5+7,"week1",IF('Date'[Rank]>=5+7&&'Date'[Rank]<=5+7*2,"week2"))

    Regards,

1 Reply

  • v-cherch-msft's avatar
    v-cherch-msft
    Microsoft Employee
    7 years ago

    Hi Gillard_2 

    You may create a rank column and use IF condition to get the column.If it is not your case,please share more details for us so that we could help further on it.For example:

    Rank = RANKX('Date','Date'[Date],,ASC)
    Column = IF('Date'[Rank]>=5&&'Date'[Rank]<=5+7,"week1",IF('Date'[Rank]>=5+7&&'Date'[Rank]<=5+7*2,"week2"))

    Regards,