Forum Discussion

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

Date Format from SharePoint List to Power BI

Hello I have a SharePoint List with following settings in the Date field - Date only and Display format (Standard)  - The date is dd.mm.yyyy This list is imported into Power BI Power BI understa...
Need Help
Tips and Tricks
  • Heinrich's avatar
    Heinrich
    3 years ago

    Hello
    Thank you.
    I was able to resolve the case.
    I had to change the list settings in SharePoint.
    The locale had to be set in the SharePoint List.
    Wish you all the best.
    Thank you for your support
    Heinrich

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago

Hello
Thank you for the input.
I did that to but Power BI keeps interpreting dd as mm
Regards
Heinrich

  • Tahreem24's avatar
    Tahreem24
    Icon for Super User rankSuper User
    3 years ago

    Heinrich , Try creating a new column

    Date Column = FORMAT(DateColumn,"DD.MM.YYYY")

     

    • Heinrich's avatar
      Heinrich
      Icon for Post Partisan rankPost Partisan
      3 years ago

      Hi Thareem24

      If the old column is named "test date".
      How does the formula has to look like
      Date Column = FORMAT(DateColumn,"DD.MM.YYYY")

      i tried with 

      Date Column = FORMAT(""test date","DD.MM.YYYY")

      but that does not work.

      Could you give me a hint
      Regards
      Heinrich

      • Tahreem24's avatar
        Tahreem24
        Icon for Super User rankSuper User
        3 years ago

        Heinrich , Just the DateColumn with your actual date column 
        Date Column = FORMAT(YourTableName[test date],"DD.MM.YYYY")