@thiagoviana,
Vi que você já achou uma solução mas de qualquer forma segue uma opção em Power Query caso seja necessário!
let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjDUByIjAyNDJR0lQ1MDA6VYHYioEVzUACQaCwA=", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [Data = _t, Valor = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Data", type date}, {"Valor", Int64.Type}}),
#"Added Custom" = Table.AddColumn(#"Changed Type", "Aux", each [Valor] / Date.Day(Date.EndOfMonth([Data]))),
#"Added Custom1" = Table.AddColumn(#"Added Custom", "DataDia", each {Number.From([Data])..Number.From(Date.EndOfMonth([Data]))}),
#"Expanded DataDia" = Table.ExpandListColumn(#"Added Custom1", "DataDia"),
#"Removed Columns" = Table.RemoveColumns(#"Expanded DataDia",{"Data", "Valor"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Aux", "Valor"}, {"DataDia", "Data"}}),
#"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Valor", type number}, {"Data", type date}})
in
#"Changed Type1"