Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hi @adeeln ,
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.
Hi @adeeln ,
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.
@adeeln , you see an option under format for that
@amitchandak In Power Bi Date format show (d mmmm yyyy).But I Need this Format dd-mmm-yyyy.e.g 01-Mar-2020.
Hi @adeeln ,
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.
@adeeln ,
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!!