cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Charu Member
Member

Custom 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 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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Charu Member
Member

Re: Custom 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])
4 REPLIES 4
Super User
Super User

Re: Custom date FORMAT measure/column in Direct query mode

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

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Charu Member
Member

Re: Custom 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])
Community Support Team
Community Support Team

Re: Custom date FORMAT measure/column in Direct query mode

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

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RyanP Regular Visitor
Regular Visitor

Re: Custom date FORMAT measure/column in Direct query mode

Doesnt pad the zero for January through September :/