How to calculate machine hours in DAX

[Dane]

I have the following data in an SQL table. There are numerous Station ID's and each station ID has numerous scans per day. I would like to be able to get the first and last scan of each day and calculate the hours between those 2 times to obtain the length of time the machine was running. I am using Direct Query and was getting an error message using the min function when trying to calculate square feet per hour. 

[VahidDM · Accepted solution]

HI @Dane 

You can split the DateTime column to two columns for Time and Date, then use these codes to find the first and last time for each date:

First = calculate(MIN(table[Time]),allexcept(table,table[Date]))
Last = calculate(MAX(table[Time]),allexcept(table,table[Date]))

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[ALLUREAN]

Hi, @Dane 

Please check this example:

https://www.dropbox.com/s/tf68z9rra5aameo/How%20to%20calculate%20machine%20hours%20in%20DAX%28allure...

Did I answer your question? Please Like and Mark my post as a solution if it solves your issue. Thanks.

Appreciate your Kudos !!!

https://allure-analytics.com/

https://www.youtube.com/channel/UCndD_QZVNB_JWYLEmP6KrpA

https://www.linkedin.com/company/77757292/