24 HR Time Conversion - Data Fact Checking

[Anonymous]

Greetings Power BI Ninjas!

Your expertise is needed. I have a calculated column, RuntimeHours, which convered seconds to hours. I also have a date table with connected relationship.

PROBLEM: I am struggling to get my data to be correct. From the sample screenshot below, RuntimeHours are > 24hrs. We obviously know that this is incorrect because there are only 24 hours in a day.

SOLUTION NEEDED: Help to get the runtime hours to calculate true to the date references:

- Day = 24hrs or less

- Month = 730hrs or less

- Quarter = 2190hrs or less

- Year = 8760hrs or less

FYI, the Calendar table references are as follows:

- DayInMonth = DAY('Calendar'[Date]) -> WHOLE NUMBER data type

- Month = FORMAT('Calendar'[Date], "MMM") -> TEXT data type

- FiscalQuarterNumber = (IF ('Calendar'[CalendarMonthNumber] < 4, 4, 'Calendar'[QuarterNumber] -1)) -> WHOLE NUMBER data type

- FiscalYear = IF('Calendar'[CalendarMonthNumber] < 4, 'Calendar'[Year] -1, 'Calendar'[Year]) -> WHOLE NUMBER data type

FYI, the RuntimeHours reference are as follows:

-  RuntimeHours = (([RuntimeSeconds] / 60) / 60) -> Decimal Number -> meaning 812seconds = 0.23 hours

Any assistance to get this data correct will be greatly appreciated! THANK YOU!!

[AlB]

Hi @Anonymous

Where is the seconds value you want to convert to hours? What is the code for [RuntimeSeconds]? Is it a measure or a column?

Is 'RuntimeHours' supposed to be a measure? If so, where and how will you use it?

[Anonymous]

@AlB Thank you for your response. RuntimeSeconds is the raw data so it is a column and I created a calculated column to convert the seconds to hours (RuntimeHours). RuntimeHours was created as a calculated column.

I am not sure on how to create RuntmeHours as a measure. The current calculated column is as follows

RuntimeHours = (([RuntimeSeconds] / 60), 60)

Any ideas on how I should proceed?

[v-chuncz-msft]

@Anonymous,

Make sure the data in [RuntimeSeconds] are correct. You may use DAX Studio to capture queries.