Subtract two Date/Time columns in Power BI

powerbi powerbi-desktop
Ahmed10 picture Ahmed10 · Aug 27, 2018 · Viewed 18.3k times · Source

How do I subtract two Date/Time columns in Power BI.

If I have:

Image

How do I find out the time difference between Last Updated and Created Time (in hours)?

Answer

RADO picture RADO · Aug 27, 2018

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

Related questions

Creating a Measure that returns DISTINCT COUNT by Country and Brand in Power BI

I have a table like below: Country, Advertiser, Brand, Spend C1, A1, B1, 10 C1, A1, B2, 5 C1, A2, B3, 0 C1, A2, B4, 20 C2, A1, B1, 8 C2, A1, B5, 7 C2, A2, B6, 4 C2, A2, B3, 3 C2, A2, B7, 2 C2, A3, B8, 9 …

Read More
Show/Hide column in Power BI Table/Matrix visual

Is there any possibility to show or hide the column in Table/Matrix visual in Power BI report by user dynamically? For Example, I have a table view with columns COLUMN-1, COLUMN-2, COLUMN-3. Now I may have filter drop down …

Read More
Counting TRUE() and False() in Power BI Using COUNTAX and FILTER

I have a column (Column_Name) in a table (Table_Name) that contains boolean (0 | 1) values. I am trying to get a count for each value. For example, I have 1500 total rows and I'd like to have 2 Measures that show 700 are …

Read More