Unix Timestamp conversation results in wrong value

[denho]

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 fix it?

Thanks in advance

[denho]

Hi,

is this maybe a bug in the power bi desktop software?

[Anonymous]

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.

[denho]

Hi,

i tried you code and got excact the same values, but it didnt fix my issue.

I still get th wrong results.

i have attached an example file...

https://1drv.ms/u/s!AvOFLEsZBfitlME_S-LhwFUm4Kqufg?e=TaNDgE

Thanks

[denho]

Thanks for your help, but thats what i have already have done.

Any row has still the same value 1/20/1970 regardless of the value of the source column

[amitchandak]

@denho , refer if these 2 can help

https://community.fabric.microsoft.com/t5/Desktop/Converting-UNIX-time-to-Date-in-PowerBI-for-Deskto...

https://whatthefact.bi/power-bi/dax/convert-unix-timestamp-to-date-or-datetime-format-in-power-bi/