How to capitalize months abbreviation group in Direct Query and Import Mode

[Anonymous]

Hi Guys,

I have added a group discretize by 1 month, i was wondering how i could capitalize months abbreviation formatting ("mmm") , is there a way via direct query or it should be done in sql. I am using the following functionallity.

Thank you in advance, for your great support.

[amitchandak · Accepted solution]

@Anonymous , Power Query will give in init case only. So you need an upper case, use the upper function in a new column.

Few column calculations are allowed in the direct query

New Month = Upper([Upper])

Else you have to bring from Database