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