Measure Reverse Date

Occasional Contributor

 

I have a calculated column that will not allow me to change to date so i created a measure. This works but the date format is backwards. Is there an additional piece of code i can put to reverse the date?

jamescosten_0-1666362669604.png

 

3 Replies

@jamescosten your  screenshot is not showing a SharePoint list directly but is excel or power bi. So I think you'll need to look at your date formats in whatever app it is rather than in SharePoint.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

The Calculated column is date only format, yet when imported to BI includes the data in the image. It wont let me change it in BI and there are no additional settings in the list.

 

Calculated columns in SharePoint are not real "date" columns (even if you set the type to date), but more or less just a fancy string.
So it gets exported as a string containing a datetime timestamp.

 

In Power BI you need to transform the column type to date first and then transform the column to just show the date part of the datetime...

 

Something like this

#"LastTableRow"=....
#"Changed Type"=Table.TransformColumnTypes(#"LastTableRow",{{"Calculated TO Date", type date}})
#"Converted Date"=Table.TransformColumns(#"Changed Type",{{"Calculated TO Date", DateTime.Date, type date}})

 

 

@jamescosten