How to change hours into days?

[Pragati11 · Accepted solution]

Hi @Anonymous ,

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

hours_to_days = [your hour fileld]/24

Thanks,

Pragati

[v-luwang-msft]

Hi @Anonymous ,

According picture,I could see the error:

In dax :

and:  &&  

or:  || 

if a and b :if(a&&b,,)

if a or b :if(a||b,,)

And you could create a new case ,then provide details pbix file ,technical support will follow up on your questions after the case created.

Best Regards

Lucien

[v-luwang-msft · Accepted solution]

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

[Anonymous]

will you please help to know what's wrong with this Dax? 

Thank you 

Astha Nigam

[Anonymous]

Hi @v-luwang-msft 

Thank you for your help. It actually worked exactly what I wanted. 

[Pragati11 · Accepted solution]

Hi @Anonymous ,

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

hours_to_days = [your hour fileld]/24

Thanks,

Pragati

[Anonymous]

Hi @Pragati11 

Thank you for your help.