Oct 21 2022 07:31 AM
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?
Oct 22 2022 05:35 AM
@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)
Oct 24 2022 12:05 AM
Oct 24 2022 01:42 AM
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}})