Custom date FORMAT measure/column in Direct query mode

[Charu]

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 mode

2.In Measure couldn't call the date column from the table.

Like Measure=FORMAT('Table1'[Created_Date],"dd-mm-yyyy")

Kindly please help me out on this.

Thanks in advance

[BhaveshPatel]

You 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 · Accepted solution]

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

[Anonymous]

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

[RyanP]

Doesnt pad the zero for January through September 😕

[v-cherch-msft]

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