Check dd/mm/yyyy format for a calculated column which is in text format

[aanchalshah18]

Hi All,

How can I identify/check if the text written in a calculated column, is in dd/mm/yyy format? It is a text field..

I cannot use R/Python for calculated columns!

[v-kelly-msft · Accepted solution]

Hi  @aanchalshah18 ,

Go to data view,select the column which you need to use in the calculated column, you will find the format and data type above in the menu bar.

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@aanchalshah18, If all Dates in that format, use this setting

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/...