So how do you take the date 2, minus the date 1 and get it into an HH:MM:SS format or a format that can be converted to a HH:MM:SS format once in the Pivot Table?
Latest Posts
- The ALL() Function in DAX
- Power Pivot Crashes–Another Update from Seattle
- The Latest and Best Way to Catch/Capture/Inspect Slicer Selections
- Mighty Morphing Pivot Tables or: How I learned to automatically change hierarchy levels on rows
- 5 Useful Data Analysis Expressions (DAX) Functions for Beginners
- Handling Missing Members In The CubeSet() Function With Power Pivot
- Compare equivalent periods in DAX
- DAX Time Intelligence for Beginners
- How Many Working Days Has An Employee Been Off Work?
- How to Document DAX Measures in Excel
Most Popular
- List of PowerPivot DAX functions with description
- Q: How can I calculate difference between two dates in DAX (seconds, minutes, hours, days and months)
- DAX cheat sheet
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- How to install PowerPivot for Excel and list of know issues
- List of suggested datasets to test PowerPivot
- PowerPivot DAX function list with samples
- Q: How can I check what version of PowerPivot for Excel is installed on my machine?