Forum Discussion

NLeelakrishna's avatar
NLeelakrishna
Frequent Visitor
8 years ago

How to change format for date field with DAX expression while get data as direct query in power BI

Hi,   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 ...
Need Help
JoHo_BI's avatar
JoHo_BI
Icon for Responsive Resident rankResponsive Resident
8 years ago

As far as I know it get taken from your local DateTime settings and there's no way to override it without DAX

kskarthick's avatar
kskarthick
Icon for Advocate I rankAdvocate I
8 years ago

Thank you Joho for your confirmation.