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
- Charu
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])
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