DateTime Format formula

[msalas]

Hello,

Can someone help me with this formula? What I want done is that anything on my "Week No." column that has 1-4, in the new column "Months", it comes up as "Jan", 5-8 is "Feb", and so on. But I'm getting an error on the dash after 2022. It works fine in Alteryx but not sure if the formula is different in Power BI.

DateTimeFormat(DateTimeAdd(DateTimeAdd('2022-01-01',-ToNumber(DateTimeFormat('2022-01-01','%w')),'Days'),7*[Week No.],'Days'),'%b')

[artemus · Accepted solution]

I think the formula would be:

Date.ToText(#date(2022, 1, 1) + [Week No.] * #duration(7, 0, 0, 0), [Format = "MMM", Culture = "en-us"])

[msalas]

That worked, thank you. 

[serpiva64]

Hi,

i think you have to use " instead of '.