Forum Discussion
Post PatronCustom date FORMAT measure/column in Direct query mode
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])
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
Post PatronHi BhaveshPatel
Thank you so much for your Idea.
The below calculated column worked fine.
RyanPAdvocate II
Doesnt pad the zero for January through September :/
v-cherch-msftMicrosoft Employee
Hi Charu
Glad to hear you've solved it, kindly mark your answer as a solution.that way, other community members will easily find the solution when they get same issue.
Regards,
Cherie
Hi Charu RyanP BhaveshPatel v-cherch-msft
What we need to do if we want to add 0 in prefix of jan to sep.
Thanks