Forum Discussion

jamescosten's avatar
jamescosten
Brass Contributor
Oct 21, 2022

Measure Reverse Date

 

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?

 

SharePoint Online
  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Oct 22, 2022

    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)

    • jamescosten's avatar
      jamescosten
      Brass Contributor
      Oct 24, 2022
      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.
      • SvenSieverding's avatar
        SvenSieverding
        Bronze Contributor
        Oct 24, 2022

         

        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 

Resources