Power Query Question: Is it possible to create a conditional column referencing dates/date column

[indrajeet_rajput]

So would it be possible to create a conditional column in power query referencing a date column example order date
So, if order dates are from 12/2/2024 to 12/8/2024 it returns "Week 1" else if dates are from 12/9/2024 to 12/15/2024 it returns "Week 2" else if dates are from 12/16/2024 to 12/22/2024 it returns "Week 3" and so on...

 

[Sergius]

Choose a column, "order date". Select “Add a column”> “Date”> “Week of the month”.

 

[Shortmeister1]

How about something like this:

let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    ChangedType = Table.TransformColumnTypes(Source,{{"order date", type date}}),
    AddSeedDate = Table.AddColumn(ChangedType, "seed date", each Date.FromText("01/12/2024"), Date.Type),
    AddWeekNo = Table.AddColumn(AddSeedDate, "WeekNo", each Number.RoundUp(Duration.Days([order date] - [seed date])/7)),
    RemoveSeedDate = Table.RemoveColumns(AddWeekNo,{"seed date"})
in
    RemoveSeedDate