Forum Discussion
Solved
Converting Google bigQuery timestamp in Power Query
Hi folks,
Is it possible to convert a Google bigQuery timestamp as a date in Power Query?
The solution is =>
= Table.AddColumn(#"Personnalisée ajoutée1", "DATE-ACTIVATION-CARTE", each #datetime(1970,1,1,0,0,0)+#duration(0,1,0,[#"DATE-ACTIVATION-CARTE-TEMP"]))
Thank you myself.
🙂
1 Reply
The solution is =>
= Table.AddColumn(#"Personnalisée ajoutée1", "DATE-ACTIVATION-CARTE", each #datetime(1970,1,1,0,0,0)+#duration(0,1,0,[#"DATE-ACTIVATION-CARTE-TEMP"]))
Thank you myself.
🙂