How to change hours into days?

Hi Anonymous ,

 

To convert Hours to Days, you can simply divide your field by 24.

 

hours_to_days = [your hour fileld]/24

 

Thanks,

Pragati

Hi Anonymous ，

Try the following dax to create new column:

day1 = 'Table'[Hour]/24

day2 = int('Table'[Hour]/24) & " Days, " & mod(INT('Table'[Hour]),24)   & " hours"

Final you will get:

 

Wish it is helpful for you!

 

Best Regards

Lucien