Forum Discussion

arvindyadav's avatar
arvindyadav
Post Partisan
8 years ago
Solved

How Can I Convert Milliseconds Value into Date

Hi Team,

 

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

 

Regards,

Arvind

Need Help

4 Replies

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Hi arvindyadav

     

    THis might be close

     

    Measure = DATEVALUE("1970-1-1") + (1514851200000 /(60*60*24*1000))
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

       

      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's avatar
        Anonymous
        Not applicable
        2 years ago

        Hello,

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