koenvb
commented
6 years ago As mentioned in #8 to work around this I did the following:
- Convert the date first to datetimezone
- Then after that, so a two step approach, convert your date to date type
It seems Power BI does not like the formatting:
2018-02-15T23:38:08Z
So with this two step approach you go from:
ORIG: 2018-02-15T23:38:08Z TMZ: 15/02/2018 11:38:08 PM +00:00 FINAL: 16/02/2018
Seems not to be possible to do it in one go.
Loving this tool. Having a problem with the formatting of opportunity dates. Power BI saying can't format the data in the field as dates.