Forum Discussion
marcmen
Helper I
Helper IDate as Number back to date
Hi All, I am trying to create a table of dates based on start and end dates. I have converted the difference between these dates into a numerical value, but I cannot convert them back to dates. In PQ...
Hi,
i think you have to convert it to a table, then change type to while number
and finally
= Table.TransformColumnTypes(#"Changed Type",{{"Column1", type date}})
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
