Forum Discussion
Charu
Post Patron
Post PatronCustom 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...
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])
CharuPost Patron
Post PatronHi 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
Advocate II
Advocate IIDoesnt pad the zero for January through September :/