Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
All, all, all, all,
I have several date/time columns. Start_date, Mid_date, End date. In power query I want to calculate how much time there is between e.g. Start_date& Mid_date, Mid_date & end_date.
I thought the best way to do this was to use several extra columns in Power Query.
How do I do that?
Or do I do this better through a measure in PowerBi (DAX)?
Solved! Go to Solution.
Data sample
TicketNr | Resolution_Actual_Date | TimeBetween | Solved_Date |
INC-445996 | 29/01/2020 9:43 | 29/01/2020 9:43 | |
INC-447487 | 31/01/2020 15:23 | 31/01/2020 15:23 | |
INC-455787 | 29/01/2020 9:15 | 29/01/2020 9:15 | |
INC-462611 | 6/02/2020 21:30 | 6/02/2020 21:30 | |
INC-466326 | 31/01/2020 11:58 | 31/01/2020 11:58 | |
INC-466623 | 31/01/2020 13:03 | 31/01/2020 13:03 | |
INC-472084 | 7/02/2020 12:40 | 7/02/2020 12:40 |
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.