How Can I Convert Milliseconds Value into Date

[arvindyadav]

Hi Team,

How to convert milliseconds value i.e, 1514851200000 into the date in power bi?

Regards,

Arvind

[Phil_Seamark · Accepted solution]

Hi @arvindyadav

THis might be close

Measure = DATEVALUE("1970-1-1") + (1514851200000 /(60*60*24*1000))

[Anonymous]

Hello,

i have a question if you allow i have a text column customerdate= 1546038000000

for example, how can i use the name of my column [customerdate] in this formula and create the measure

Thank's in advance.

[Anonymous]

Hello,

You need to right-click on your table and create a new column instead of a measure.

[arvindyadav]

Hi @Phil_Seamark,

Thanks Phil,

It is work for me.

Regards,

Arvind