Forum Discussion
WFKoth
6 years agoRegular Visitor
Datediff not recognized
So I've got this problem: https://community.powerbi.com/t5/Desktop/Time-Difference-between-Rows-Grouped-by-Location-Averaged-over/m-p/947401#M453998 And I've gotten this far: ...
- 6 years ago
Hi WFKoth ,
You mistake it for M query. You need to use this DAX to create a new column.
If all you want is M query, you could try Duration.Hour() to get time difference.
amitchandak
6 years agoSuper User
To take datediff in M refer
Datediff is there in dax.
Please refer to this file, this has few ways to take date diff.
Check for Way1,2,3,
https://www.dropbox.com/s/y47ah38sr157l7t/Order_delivery_date_diff.pbix?dl=0