Forum Discussion
yjk3140
4 years agoHelper I
Calculating difference between two timestamps using DAX
Hi, I need to create a DAX measure which calculates difference in hours between two timestamp columns in a table. the date format for those columns is yyyy-mm-ddThh:mm:ss:00.000+0000 ex) 2022-05-03...
Anonymous
4 years agoNot applicable
Hi yjk3140 - I spotted this community posing that suggested that Direct Query was not available for datetimestamps with milliseconds. Solved: Convert UNIX timestamp to DateTime using Direct Qu... - Microsoft Power BI Community. Is there anyway to change the Databricks table to include the Unix TimeStamp as columns without the need for the addition of the unix_timestamp() function in Power BI query?