Forum Discussion

Charu's avatar
Charu
Post Patron
7 years ago
Solved

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 m...
Need Help
  • Charu's avatar
    Charu
    7 years ago

    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])
Charu's avatar
Charu
Post Patron
7 years ago

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])
RyanP's avatar
RyanP
Advocate II
7 years ago

Doesnt pad the zero for January through September :/