Forum Discussion
Dataflow Null Date Value
Hello Anonymous
this is what might happen, that you don't have a text string on your whole column, but somewhere at the end a date. And it's not possible to parse a date. So you have to do a transform.columntype of this column before, and change it to text. Did you try this?
Here an example of what happen when you try to split a date
let Source = #table ( {"Date"}, { {"03.01.19-04.01.19"}, {"43468"} } ), ToDate = Table.TransformColumns(Source, {{"Date", each try Date.From(Number.From(_)) otherwise _}}), Split = Table.SplitColumn(ToDate, "Date", Splitter.SplitTextByAnyDelimiter({"-"})) in SplitBy the way... you don't need to parse it by "/". Just use a transformColumns with a Date.FromText(_,"en-US") i suppose
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
I'm using dataflows on the power BI service. It's essentially Power Query online - but its just a little different than PQ in PBI Desktop.
I'm initially parsing out the dates because they're a part of a string - the first one I parse is a six digit date, and the only way that I know to get it into date format is to parse it out and then merge with the "/" as the separator.
In my example, I initially didn't have to parse it out a second time (and maybe don't need to at all) I was just trying to see if it would clear my error.
Hello Anonymous
have you been able to solve the problem with the replies given?
If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
Jimmy