Solved: Re: Show time increment in decimal

Novice100 · ‎03-31-2022

Hello Community,

I need help in writing a DAX to show time increment in decimal format.

Something as shown in the table below:

Thanks in advance,

Saurav

amitchandak · ‎03-31-2022

@Novice100 , Based on What I got, A new column in DAX

Mid([Time in (HH:MM:SS)], 10,5)

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

View solution in original post

Novice100 · ‎03-31-2022

Great, Thanks!

amitchandak · ‎03-31-2022

@Novice100 , Based on What I got, A new column in DAX

Mid([Time in (HH:MM:SS)], 10,5)

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview. ✨
️ November 12th-14th, 2024
 Online Event
Register Here

Show time increment in decimal

Helpful resources

Join us at the Microsoft Fabric Community Conference

A Year in Review - December 2024

New Offer! Become a Certified Fabric Data Engineer

Show time increment in decimal

Helpful resources

Join us at the Microsoft Fabric Community Conference

A Year in Review - December 2024