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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Try change the regional settings of Power BI, and then re-format your date. This allows you to change the format from dd/mm/yyyy to mm/dd/yyyy. Remember this is global setting, all your date will be changed based on your selection

 

 

 

 

NLeelakrishna's avatar
NLeelakrishna
Frequent Visitor
8 years ago

Hi Jessica,

 

Thanks for your reply. We have tried as you given information , we got many formats. But we need "dd-MMM-yyyy hh:mm:ss"

(22-Mar-2018 02:07:43) format. that is not available in that formats. This format we can achive by using DAX only or any other options is there? If any options avaliable pls let us know.

 

Thank you.