Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Mabel_dlp_999
Frequent Visitor

Time Value Clean-up?

I'm looking for the best way to clean my time data into one column. For this example, I have two columns.

Coulmn 1 is an integer between 1 and 24
Coulmn 2 is a text string that equals either Hours, Days, or Weeks

Example 1: In row 1, Col1 = 3 & Col 2 = Hours--> This would be 3 Hours
Example 2: In row 2, Col1 = 2 & Col2 = Days --> This would be 2 Days
Example 3: In row 3, Col1 = 4 & Col2 = Weeks --> This would be 4 Weeks

I know I could just merge the two together columns, but I'm concered doing so may not work with measures I create off this data. Any suggestions?

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@Mabel_dlp_999 I would pick a time granularity and just convert everything into hours, minutes, or seconds for example.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Mabel_dlp_999
Frequent Visitor

@Greg_Deckler Thanks so much for the speedy answer! You're the bomb, I was able to create a new column to show everything in terms of hours. 

Thanks again!

Greg_Deckler
Community Champion
Community Champion

@Mabel_dlp_999 I would pick a time granularity and just convert everything into hours, minutes, or seconds for example.



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.