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!
Go to 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.
View solution in original post
@aanchalshah18, If all Dates in that format, use this setting
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.