Forum Discussion

WFKoth's avatar
WFKoth
Regular Visitor
6 years ago
Solved

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:         ...
Need Help
Tutorial Requests
  • v-eachen-msft's avatar
    v-eachen-msft
    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.

     

v-eachen-msft's avatar
v-eachen-msft
Icon for Community Support rankCommunity Support
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.