Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
Solved! Go to Solution.
@Mabel_dlp_999 I would pick a time granularity and just convert everything into hours, minutes, or seconds for example.
@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!
@Mabel_dlp_999 I would pick a time granularity and just convert everything into hours, minutes, or seconds for example.