How to calculate and show week of month

[Sriku]

Hi All,

I want calculate week of a particlar month as to been shown as w1, w2, w3 etc. 

example Sep month it should be w1, w2, w3 etc

[Anonymous · Accepted solution]

Hi @Sriku ,

Check the formula.

Column =
VAR som =
    STARTOFMONTH ( 'Table'[date] )
VAR dat = 'Table'[date]
RETURN
    SWITCH (
        TRUE (),
        dat >= som
            && dat < som + 7, "w1",
        dat >= som + 7
            && dat < som + 14, "w2",
        dat >= som + 14
            && dat < som + 21, "w3",
        dat >= som + 21
            && dat < som + 28, "w4",
        "w5"
    )

Result would be shown as below.

Best Regards,

Jay

[amitchandak]

@Sriku , First of all have week start date

Week Start date = 'Date'[Date]+-1*WEEKDAY('Date'[Date],2)+1

and month year

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

min week start of month = minx(filter('Date',[Month Year] =earlier([Month Year])),[Week Start date])

try a column like

week of month = datediff([min week start of month],[date],Week)