Forum Discussion

VoltesDev's avatar
VoltesDev
Icon for Helper V rankHelper V
4 years ago

Extract month full name from Date dimension in Direct Query

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

Tips and Tricks

1 Reply

  • VahidDM's avatar
    VahidDM
    Icon for Super User rankSuper User
    4 years ago

    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/