Forum Discussion
Charu
Post Patron
Post PatronCustom date FORMAT measure/column in Direct query mode
Dear All, is there any possibilities to write a DAX formula for Custom india date format like dd-mm-yyyy in a direct query mode? 1.In Calculated column FORMAT is not support in direct query m...
Hi BhaveshPatel
Thank you so much for your Idea.
The below calculated column worked fine.
Calculated Column = DAY('Table1'[Creation_Date]) & "/" & MONTH('Table1'[Creation_Date]) & "/" & YEAR('Table1'[Creation_Date])
BhaveshPatel
Super User
Super UserYou can try splitting your date column in query editor and then using the merge columns feature, combine as per the indian date format. "dd-mm-yyyy".
In case, this step may not be supported then you can use combination of LEFT, RIGHT functions to extract dd, mm, yyyy and then concatenate all together.
Thanks
Bhavesh
CharuPost Patron
Post PatronHi BhaveshPatel
Thank you so much for your Idea.
The below calculated column worked fine.
Calculated Column = DAY('Table1'[Creation_Date]) & "/" & MONTH('Table1'[Creation_Date]) & "/" & YEAR('Table1'[Creation_Date])