Extract month full name from Date dimension in Direct Query

[VoltesDev]

Hi friends,

How to extract a date column and get a month full name, but in Direct Query. Normally I found blogs explain to use FORMAT(), but Direct Query not supporting this, and I can't use Mixed mode as well.

Thanks

[VahidDM]

Hi @VoltesDev 

Try this code to add a new custom column:

Date.ToText([Date],"MMMM")

output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/