Date field from Softools coming up as a text field on Power BI - What do people do?

Follow

Permanently deleted user

• 01 October 2019 06:48
• Edited

Converting UNIX time to Date in PowerBI

There are scenarios when the dates from Softools come up with long numbers. Here is a guidance article from the Power BI community that provides guidance on converting those numbers to a date format column on Power BI.

The values there are UNIX time stamps for time since EPOCH. Would need this type of expression to convert them.
https://community.powerbi.com/t5/Desktop/Converting-UNIX-time-to-Date-in-PowerBI-for-Desktop/m-p/132066#M56340

Example of how the date looks like when first getting the data from Softools.

0

• 

  Permanently deleted user

  • 11 February 2020 18:20

  Here is a video on You Tube that helped me to convert my values. https://www.youtube.com/watch?v=BY0WV05IeNk

  0

  Comment actions Permalink

Please sign in to leave a comment.