Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
hannsen13
Frequent Visitor

normalise YYYY/MM/DD hh:mm:ss

‎08-03-2024 10:52 AM

How to normalise YYYY/MM/DD hh:mm:ss among multiple processing runs using DAX?

 

Subtract the elapsed time from the first timestamp across all runs, not going to work because YYYY/MM/DD hh:mm:ss not in chronology. YYYY/MM/DD hh:mm:ss is in 1 column

 

DateTimeStepNoStepTimeStepTotalStepCommentDOE LegAttributeValue
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC100_PV1.29
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC101_PV1
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC110_PV0.6
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC111_PV10.64
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC300_PV450
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC301_PV49.9
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC320_PV494.1
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC321_PV5.79
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC330_PV401.4
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC331_PV98.4
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC340_PV3.1
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC341_PV2.6
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC350_PV399.9
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC351_PV99.9
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC610_PV7.7
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC620_PV9.99
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC650_PV1
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC660_PV0.5
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC670_PV0.99
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC690_PV0.48
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC710_PV1.46
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC720_PV0.08
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC730_PV0.27
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC740_PV0.09
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC680_PV0.19
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC780_PV9.99
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC782_PV10
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC705_PV2
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC706_PV1
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC707_PV4
7/5/2024 3:11:11 AM837623.8AlN100NMM1311_ML200MFC708_PV3
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC100_PV1.29
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC101_PV0.999
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC110_PV20.3
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC111_PV10.72
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC300_PV449.9
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC301_PV50
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC320_PV494.1
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC321_PV5.79
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC330_PV401.4
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC331_PV98.4
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC340_PV3
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC341_PV2.6
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC350_PV399.9
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC351_PV99.9
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC610_PV7.69
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC620_PV9.99
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC650_PV1
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC660_PV0.5
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC670_PV0.99
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC690_PV0.479
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC710_PV1.43
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC720_PV0.08
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC730_PV0.28
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC740_PV0.09
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC680_PV0.19
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC780_PV9.99
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC782_PV9.99
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC705_PV2
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC706_PV1
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC707_PV4
7/5/2024 3:11:12 AM847626AlN100NMM1311_ML200MFC708_PV3
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC100_PV1.29
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC101_PV0.999
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC110_PV20
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC111_PV10.73
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC300_PV449.9
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC301_PV50
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC320_PV494.1
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC321_PV5.79
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC330_PV401.4
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC331_PV98.4
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC340_PV3
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC341_PV2.6
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC350_PV399.9
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC351_PV99.9
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC610_PV7.69
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC620_PV9.97
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC650_PV0.999
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC660_PV0.5
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC670_PV0.99
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC690_PV0.479
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC710_PV1.41
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC720_PV0.08
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC730_PV0.27
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC740_PV0.09
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC680_PV0.19
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC780_PV9.99
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC782_PV9.99
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC705_PV1.999
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC706_PV1
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC707_PV3.99
7/5/2024 3:11:13 AM857627.8AlN100NMM1311_ML200MFC708_PV3
Labels:
Message 1 of 6
372 Views
0
1 ACCEPTED SOLUTION
lbendlin
Super User
Super User
In response to hannsen13

‎08-05-2024 06:07 AM

You can use a calculated column for that.  

 

lbendlin_0-1722863265812.png

 

View solution in original post

DOE leg.pbix
Message 6 of 6
265 Views
0
5 REPLIES 5
lbendlin
Super User
Super User

‎08-03-2024 11:23 AM 
Subtract the elapsed time from the first timestamp across all runs,

None of these words seem to relate to your sample data. Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?

Message 2 of 6
354 Views
0
hannsen13
Frequent Visitor
In response to lbendlin

‎08-05-2024 05:26 AM

My end in mind plot will look like this...

hannsen13_0-1722860119253.png

I am trying to normalised time so I can stacked both legs run at different time with same parameter.

 

DateTimeStepNoStepTimeStepTotalStepCommentDOE LegAttribute
7/4/2024 8:25:13 PM1017889.6AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:14 PM1027891.2AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:15 PM1037893.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:16 PM1047895.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:17 PM1057897.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:18 PM1067899.2AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:19 PM1177901.6GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:20 PM1117903.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:21 PM1127905.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:22 PM1137907.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:23 PM1147909.6GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:24 PM1157911.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:25 PM1167913.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:26 PM1177915.6GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:27 PM1187917.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:28 PM1197919.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:29 PM11107921.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:30 PM11117923.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:31 PM11127925.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:32 PM11137927.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:33 PM11147929.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:35 PM1017933AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:36 PM1027934.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:37 PM1037936.2AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:38 PM1047938.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:39 PM1057940.6AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:40 PM1067942.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:41 PM1177944.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:42 PM1117946.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:43 PM1127948.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:44 PM1137950.6GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:45 PM1147952.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:46 PM1157954.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:47 PM1167956.8GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:48 PM1177958.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:49 PM1187960.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:50 PM1197962.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:51 PM11107964.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:52 PM11117966.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:53 PM11127968.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:54 PM11137970.4GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:55 PM11147972.2GaN 20nmM1313_ML200MFC300_PV
7/4/2024 8:25:56 PM1017975.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:57 PM1027977.2AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:58 PM1037979.4AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:25:59 PM1047981.6AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:26:00 PM1057983.2AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:26:01 PM1067985.2AlN5NMM1313_ML200MFC300_PV
7/4/2024 8:26:02 PM1077987.2AlN5NMM1313_ML200MFC300_PV
7/5/2024 3:13:06 AM1017854AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:07 AM1027855.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:08 AM1037857.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:09 AM1047859.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:10 AM1057861.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:11 AM1117865GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:12 AM1127866.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:13 AM1137868.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:14 AM1147871GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:15 AM1157872.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:16 AM1167875.2GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:17 AM1177877GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:18 AM1187879GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:19 AM1197880.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:20 AM11107882.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:21 AM11117884.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:22 AM11127886.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:23 AM11137888.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:24 AM11147891GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:26 AM1017894AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:27 AM1027895.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:28 AM1037897.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:29 AM1047899.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:30 AM1057902AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:31 AM1117905.2GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:32 AM1127906.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:33 AM1137908.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:34 AM1147910.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:35 AM1157913GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:36 AM1167914.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:37 AM1177916.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:38 AM1187918.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:39 AM1197921GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:40 AM11107923GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:41 AM11117924.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:42 AM11127926.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:43 AM11137929GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:44 AM11147930.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:46 AM1017934.4AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:47 AM1027935.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:48 AM1037937.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:49 AM1047939.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:50 AM1057941.8AlN5NMM1311_ML200MFC300_PV
7/5/2024 3:13:51 AM1117945GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:52 AM1127947GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:53 AM1137949GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:54 AM1147950.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:55 AM1157952.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:56 AM1167955GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:57 AM1177957GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:58 AM1187959.2GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:13:59 AM1197960.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:14:00 AM11107963GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:14:01 AM11117965GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:14:02 AM11127966.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:14:03 AM11137968.8GaN 20nmM1311_ML200MFC300_PV
7/5/2024 3:14:04 AM11147971GaN 20nmM1311_ML200MFC300_PV
Message 3 of 6
276 Views
0
lbendlin
Super User
Super User
In response to hannsen13

‎08-05-2024 05:37 AM

What happened to the seconds in your sample data? What's that new MS column doing?

Message 4 of 6
272 Views
0
hannsen13
Frequent Visitor
In response to lbendlin

‎08-05-2024 05:56 AM

I have updated the table.

My bad. The date time format was changed when I pasted it onto Excel.

Message 5 of 6
268 Views
0
lbendlin
Super User
Super User
In response to hannsen13

‎08-05-2024 06:07 AM

You can use a calculated column for that.  

 

lbendlin_0-1722863265812.png

 

DOE leg.pbix
Message 6 of 6
266 Views
0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All