Forum Discussion
Solved
Incremental refresh using datetime
Hello we have a dataset whereby the rows contained a datetime field. But because of the high cardinality we splitted this in a date and a time field. We have to refresh this data on a daily bas...
Yes. That was your goal, to keep the cardinality low, right?
Sure. All you need is to cast your date field as datetime during the comparison (basically pegging the time at midnight)
Like so:
let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMtU31DcyMDJUitUBcwyQeUYwXiwA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Column1 = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type date}}), #"Filtered Rows" = Table.SelectRows(#"Changed Type", each DateTime.From([Column1]) > RangeStart and DateTime.From([Column1]) <= RangeEnd) in #"Filtered Rows"How to use this code: Create a new Blank Query, then click on "Advanced Editor", and then replace the code in the window with the code provided here. Then click "Done".
great, thnx