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])
v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

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