Converting Google bigQuery timestamp in Power Query

[PatrickByGecko]

Hi folks,

Is it possible to convert a Google bigQuery timestamp as a date in Power Query?

[PatrickByGecko · Accepted solution]

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.

🙂