How to change format(dd/mmm/yyyy) for date field with DAX expression while get data as direct query

[Anonymous]

I want change format for date with DAX expression while direct query in Power BI. I have tried with format function in DAX but getting error like "Function 'FORMAT' is not allowed as part of calculated column DAX expressions on DirectQuery models." Date format that i wants DD/MMM/YYYY.

[v-lionel-msft]

Hi @Anonymous ,

Has your problem been solved?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , you see an option under format for that

[Anonymous]

 @amitchandak In Power Bi Date format show (d mmmm yyyy).But I Need this Format dd-mmm-yyyy.e.g 01-Mar-2020.

[v-lionel-msft · Accepted solution]

Hi @Anonymous ,

Isn't this format?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[harshnathani]

@Anonymous ,

https://community.powerbi.com/t5/Desktop/Change-date-format-in-DIRECT-Query-Mode-not-on-list-of/td-p/781155

https://community.powerbi.com/t5/Desktop/Direct-Query-transform-Date-TIme-to-Date/td-p/614651

Please check if this helps.

Regards,

Harsh Nathani

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!