Ahmed10
Reputation: 33
Subtract two Date/Time columns in Power BI
How do I subtract two Date/Time columns in Power BI.
If I have:
How do I find out the time difference between Last Updated and Created Time (in hours)?
Upvotes: 3
Views: 26351
Answers (1)
RADO
Reputation: 8148
Assuming your table is called "Table":
Time Difference = DATEDIFF('Table'[Created Time], Table[Last Updated], DAY)
DATEDIFF Function description:
https://msdn.microsoft.com/en-us/query-bi/dax/datediff-function-dax
Upvotes: 2
Related Questions
- Power Bi, Dax Syntax to subtract TODAY date with criteria from a column with repeated dates
- Subtracting values from the same column but different rows in power bi
- How do I take the difference of two datetime columns in power bi?
- How to get Date/Time difference with Current time in PowerBi
- How to subtract two time difference rows in the same column (like A2-A1) but in PowerBI
- Time Difference between two timestamps in same column DAX
- Date diff using dates in the same column DAX
- How to calculate date difference in a measure in power bi?
- How to subtract dates on different rows in POWER BI
- Difference between two dates returns date instead of number [DAX]