Forum Discussion

denho's avatar
denho
Frequent Visitor
2 years ago

Unix Timestamp conversation results in wrong value

Hi,   i have converted a column with the formula: The source column is a number format and has different values:   The result is always the wrong and same value:   How can i ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi amitchandak ,

Thanks for the quick response.

Hi denho ,

Please have a try.

let
    Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjQ3NLTUMzIyMTBQitUB842AfAtzUxNUvoWhUmwsAA==", 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 number}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type",{{"Column1", type datetime}})
in
    #"Changed Type1"

 

How to Get Your Question Answered Quickly - Microsoft Fabric Community

 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

 

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.