Tutorial with example
In today’s video, I will show you how to calculate the difference between two dates using DATEDIFF.
I also show you how to overcome the issue when the start date is larger than the end date.
Link to Northwind dataset: https://www.youtube.com/watch?v=k3NMIlLffrU
Link to DAX Switch: https://www.youtube.com/watch?v=-ykkaAtlCMc
Download example file:
Link to demo file here.
In today’s video we will deconstruct a measure that was created by a microsoft employee in the Power BI community:
Link to the Power BI community post: https://community.powerbi.com/t5/Desktop/Calculate-duration-based-on-dates-in-different-rows/td-p/58886
An error is returned if start_date is larger than end_date.