Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create Column with modification of one condition

Hi,   I have a dataset with the following   TIme Frame Latest 4 wks - 02/06/2021 Latest 13 wks - 02/06/2021 Latest 26 wks - 02/06/2021 Latest 52 wks - 02/06/2021   I am using a create colum...
Need Help
  • Tahreem24's avatar
    Tahreem24
    5 years ago

    Anonymous ,

    Create new column as WeekNum like below:

    WeekNum = WEEKNUM(Table[YourDateColumn])
    Then go to Data view then select TimeFrame Column then click on "Sort by Column" then choose the above WeekNum column. (See the attached screen shot)

     

    Final Output: