Forum Discussion
Post PartisanDate Format from SharePoint List to Power BI
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
Super User
Post PartisanHi 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
Heinrich , Just the DateColumn with your actual date column
Date Column = FORMAT(YourTableName[test date],"DD.MM.YYYY")- Heinrich
Sorry I did that but I don't think I did it right
1. = Table.AddColumn(#"Changed Type", "Test", each [Start Date])
2. = Table.TransformColumnTypes(#"Added Custom",{{"Test", type date}})
3. = FORMAT("MS Teams Enable Teams Federation"[Test],"DD.MM.YYYY")
This gives me an error. How can this be done
Regards
Heinrich