Dax formula do calculate online time

[vjalvim]

I'm looking for a dax formula to calculate OLT. Basically, I have a column called "shutdown" when we have the total hours of shutdowns in a day.

So, if I need to know the OLT for a day, I need to divide this column for 24 hours.

If I look for a OLT month, I need to divide the sum of "shutdown" for 24 hours * n. of days of the month, like below:

day = shutdowns in a day / 24 hours

month = shutdowns in a month / n. days of the month * 24

year = shutdowns in a month / n. days of the year * 24

[v-piga-msft]

Hi  @vjalvim,

It seems that we cannot calculate the month by a fixed number of days.

You could have a reference of this blog, hope this could make sense of you.

Best Regards,

Cherry