Forum Discussion
24 HR Time Conversion - Data Fact Checking
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...
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?
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?
Anonymous,
Make sure the data in [RuntimeSeconds] are correct. You may use DAX Studio to capture queries.
