Forum Discussion

msalas's avatar
msalas
Regular Visitor
3 years ago
Solved

DateTime Format formula

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')

 

 

Need Help
Tutorial Requests
  • artemus's avatar
    artemus
    3 years ago

    I think the formula would be:

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

     

3 Replies

  • artemus's avatar
    artemus
    Microsoft Employee
    3 years ago

    I think the formula would be:

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