Ideas
Open

Show Time (HH:MM:SS) for datetime data types in Table Preview and DAX Query Results

The problem is that the time components are not displayed of datetime data types in the Table Preview, DAX Query results and possibly other areas of the application. While this might seem like an esthetic request, it actually would have saved me a great deal of time in troubleshooting a problem. I wrote a DAX measure that created a date based on parts using the DATE function and then using that date to query a fact table that had time components, which I didn't realize at the time. This was causing the measure to return unexpected results. I often rely on the data preview for quick checks of the data. If I would have seen time components in the data preview, the issue would have been immediately apparent. It was a quick fix once I realized it, but it would have made my realization much faster. I realized that I missed a CAST to date in my view. Easy fix, once I found it. I would like to see the full values of datetime columns in the Data Preview, DAX Query Results and any other similar areas of the application. If there is existing reasons for only showing the date part of the datetime, a setting in preferences to determine if the time component shows or not in the various parts of the application would be helpful. - Better insight to the full value of datatime columns - Eliminate the hiding of potential existing time data. The alternative that I use now is to view the time portion of a datetime is to take the time to open another tool, such DAX Studio and run the same query. SSMS even shows the time component. While this works, it isn't part of the natural development workflow. In my case above, it didn't help until I realized what the problem was. Then I opened DAX Studio to confirm.

0 Comments

Sign in to comment

No comments yet. Be the first to share your thoughts!