'How to parse abbreviated month as Month format in data studio?

I have a field containing "Jan", "Feb", "Mar" etc and data studio does not recognize this as a valid month so i created a new field with formula

case
when REGEXP_CONTAINS(Month,'(?i)jan') then "January"
when REGEXP_CONTAINS(Month,'(?i)feb') then "Februay"
when REGEXP_CONTAINS(Month,'(?i)mar') then "March"
when REGEXP_CONTAINS(Month,'(?i)apr') then "April"
when REGEXP_CONTAINS(Month,'(?i)may') then "May"
when REGEXP_CONTAINS(Month,'(?i)jun') then "June"
when REGEXP_CONTAINS(Month,'(?i)jul') then "July"
when REGEXP_CONTAINS(Month,'(?i)aug') then "August"
when REGEXP_CONTAINS(Month,'(?i)sep') then "September"
when REGEXP_CONTAINS(Month,'(?i)oct') then "October"
when REGEXP_CONTAINS(Month,'(?i)nov') then "November"
when REGEXP_CONTAINS(Month,'(?i)dec') then "December"
end

but even this is not recognized by datastudio as Month. Kindly help

google-data-studio


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions