topic Re: normalise YYYY/MM/DD hh:mm:ss in DAX Commands and Tips https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081226#M162012 <P>My end in mind plot will look like this...</P><P><img /></P><P>I am trying to normalised time so I can stacked both legs run at different time with same parameter.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>DateTime</TD><TD>StepNo</TD><TD>StepTime</TD><TD>StepTotal</TD><TD>StepComment</TD><TD>DOE Leg</TD><TD>Attribute</TD></TR><TR><TD>7/4/2024 8:25:13 PM</TD><TD>10</TD><TD>1</TD><TD>7889.6</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:14 PM</TD><TD>10</TD><TD>2</TD><TD>7891.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:15 PM</TD><TD>10</TD><TD>3</TD><TD>7893.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:16 PM</TD><TD>10</TD><TD>4</TD><TD>7895.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:17 PM</TD><TD>10</TD><TD>5</TD><TD>7897.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:18 PM</TD><TD>10</TD><TD>6</TD><TD>7899.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:19 PM</TD><TD>11</TD><TD>7</TD><TD>7901.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:20 PM</TD><TD>11</TD><TD>1</TD><TD>7903.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:21 PM</TD><TD>11</TD><TD>2</TD><TD>7905.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:22 PM</TD><TD>11</TD><TD>3</TD><TD>7907.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:23 PM</TD><TD>11</TD><TD>4</TD><TD>7909.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:24 PM</TD><TD>11</TD><TD>5</TD><TD>7911.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:25 PM</TD><TD>11</TD><TD>6</TD><TD>7913.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:26 PM</TD><TD>11</TD><TD>7</TD><TD>7915.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:27 PM</TD><TD>11</TD><TD>8</TD><TD>7917.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:28 PM</TD><TD>11</TD><TD>9</TD><TD>7919.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:29 PM</TD><TD>11</TD><TD>10</TD><TD>7921.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:30 PM</TD><TD>11</TD><TD>11</TD><TD>7923.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:31 PM</TD><TD>11</TD><TD>12</TD><TD>7925.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:32 PM</TD><TD>11</TD><TD>13</TD><TD>7927.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:33 PM</TD><TD>11</TD><TD>14</TD><TD>7929.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:35 PM</TD><TD>10</TD><TD>1</TD><TD>7933</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:36 PM</TD><TD>10</TD><TD>2</TD><TD>7934.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:37 PM</TD><TD>10</TD><TD>3</TD><TD>7936.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:38 PM</TD><TD>10</TD><TD>4</TD><TD>7938.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:39 PM</TD><TD>10</TD><TD>5</TD><TD>7940.6</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:40 PM</TD><TD>10</TD><TD>6</TD><TD>7942.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:41 PM</TD><TD>11</TD><TD>7</TD><TD>7944.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:42 PM</TD><TD>11</TD><TD>1</TD><TD>7946.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:43 PM</TD><TD>11</TD><TD>2</TD><TD>7948.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:44 PM</TD><TD>11</TD><TD>3</TD><TD>7950.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:45 PM</TD><TD>11</TD><TD>4</TD><TD>7952.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:46 PM</TD><TD>11</TD><TD>5</TD><TD>7954.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:47 PM</TD><TD>11</TD><TD>6</TD><TD>7956.8</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:48 PM</TD><TD>11</TD><TD>7</TD><TD>7958.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:49 PM</TD><TD>11</TD><TD>8</TD><TD>7960.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:50 PM</TD><TD>11</TD><TD>9</TD><TD>7962.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:51 PM</TD><TD>11</TD><TD>10</TD><TD>7964.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:52 PM</TD><TD>11</TD><TD>11</TD><TD>7966.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:53 PM</TD><TD>11</TD><TD>12</TD><TD>7968.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:54 PM</TD><TD>11</TD><TD>13</TD><TD>7970.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:55 PM</TD><TD>11</TD><TD>14</TD><TD>7972.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:56 PM</TD><TD>10</TD><TD>1</TD><TD>7975.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:57 PM</TD><TD>10</TD><TD>2</TD><TD>7977.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:58 PM</TD><TD>10</TD><TD>3</TD><TD>7979.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:59 PM</TD><TD>10</TD><TD>4</TD><TD>7981.6</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:26:00 PM</TD><TD>10</TD><TD>5</TD><TD>7983.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:26:01 PM</TD><TD>10</TD><TD>6</TD><TD>7985.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:26:02 PM</TD><TD>10</TD><TD>7</TD><TD>7987.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:06 AM</TD><TD>10</TD><TD>1</TD><TD>7854</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:07 AM</TD><TD>10</TD><TD>2</TD><TD>7855.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:08 AM</TD><TD>10</TD><TD>3</TD><TD>7857.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:09 AM</TD><TD>10</TD><TD>4</TD><TD>7859.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:10 AM</TD><TD>10</TD><TD>5</TD><TD>7861.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:11 AM</TD><TD>11</TD><TD>1</TD><TD>7865</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:12 AM</TD><TD>11</TD><TD>2</TD><TD>7866.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:13 AM</TD><TD>11</TD><TD>3</TD><TD>7868.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:14 AM</TD><TD>11</TD><TD>4</TD><TD>7871</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:15 AM</TD><TD>11</TD><TD>5</TD><TD>7872.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:16 AM</TD><TD>11</TD><TD>6</TD><TD>7875.2</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:17 AM</TD><TD>11</TD><TD>7</TD><TD>7877</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:18 AM</TD><TD>11</TD><TD>8</TD><TD>7879</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:19 AM</TD><TD>11</TD><TD>9</TD><TD>7880.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:20 AM</TD><TD>11</TD><TD>10</TD><TD>7882.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:21 AM</TD><TD>11</TD><TD>11</TD><TD>7884.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:22 AM</TD><TD>11</TD><TD>12</TD><TD>7886.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:23 AM</TD><TD>11</TD><TD>13</TD><TD>7888.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:24 AM</TD><TD>11</TD><TD>14</TD><TD>7891</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:26 AM</TD><TD>10</TD><TD>1</TD><TD>7894</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:27 AM</TD><TD>10</TD><TD>2</TD><TD>7895.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:28 AM</TD><TD>10</TD><TD>3</TD><TD>7897.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:29 AM</TD><TD>10</TD><TD>4</TD><TD>7899.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:30 AM</TD><TD>10</TD><TD>5</TD><TD>7902</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:31 AM</TD><TD>11</TD><TD>1</TD><TD>7905.2</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:32 AM</TD><TD>11</TD><TD>2</TD><TD>7906.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:33 AM</TD><TD>11</TD><TD>3</TD><TD>7908.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:34 AM</TD><TD>11</TD><TD>4</TD><TD>7910.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:35 AM</TD><TD>11</TD><TD>5</TD><TD>7913</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:36 AM</TD><TD>11</TD><TD>6</TD><TD>7914.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:37 AM</TD><TD>11</TD><TD>7</TD><TD>7916.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:38 AM</TD><TD>11</TD><TD>8</TD><TD>7918.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:39 AM</TD><TD>11</TD><TD>9</TD><TD>7921</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:40 AM</TD><TD>11</TD><TD>10</TD><TD>7923</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:41 AM</TD><TD>11</TD><TD>11</TD><TD>7924.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:42 AM</TD><TD>11</TD><TD>12</TD><TD>7926.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:43 AM</TD><TD>11</TD><TD>13</TD><TD>7929</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:44 AM</TD><TD>11</TD><TD>14</TD><TD>7930.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:46 AM</TD><TD>10</TD><TD>1</TD><TD>7934.4</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:47 AM</TD><TD>10</TD><TD>2</TD><TD>7935.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:48 AM</TD><TD>10</TD><TD>3</TD><TD>7937.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:49 AM</TD><TD>10</TD><TD>4</TD><TD>7939.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:50 AM</TD><TD>10</TD><TD>5</TD><TD>7941.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:51 AM</TD><TD>11</TD><TD>1</TD><TD>7945</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:52 AM</TD><TD>11</TD><TD>2</TD><TD>7947</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:53 AM</TD><TD>11</TD><TD>3</TD><TD>7949</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:54 AM</TD><TD>11</TD><TD>4</TD><TD>7950.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:55 AM</TD><TD>11</TD><TD>5</TD><TD>7952.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:56 AM</TD><TD>11</TD><TD>6</TD><TD>7955</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:57 AM</TD><TD>11</TD><TD>7</TD><TD>7957</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:58 AM</TD><TD>11</TD><TD>8</TD><TD>7959.2</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:59 AM</TD><TD>11</TD><TD>9</TD><TD>7960.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:00 AM</TD><TD>11</TD><TD>10</TD><TD>7963</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:01 AM</TD><TD>11</TD><TD>11</TD><TD>7965</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:02 AM</TD><TD>11</TD><TD>12</TD><TD>7966.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:03 AM</TD><TD>11</TD><TD>13</TD><TD>7968.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:04 AM</TD><TD>11</TD><TD>14</TD><TD>7971</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR></TBODY></TABLE> Mon, 05 Aug 2024 12:54:55 GMT hannsen13 2024-08-05T12:54:55Z normalise YYYY/MM/DD hh:mm:ss https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4077615#M161912 <P>How to normalise YYYY/MM/DD hh:mm:ss among multiple processing runs using DAX?</P><P>&nbsp;</P><P>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</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>DateTime</TD><TD>StepNo</TD><TD>StepTime</TD><TD>StepTotal</TD><TD>StepComment</TD><TD>DOE Leg</TD><TD>Attribute</TD><TD>Value</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC100_PV</TD><TD>1.29</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC101_PV</TD><TD>1</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC110_PV</TD><TD>0.6</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC111_PV</TD><TD>10.64</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD><TD>450</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC301_PV</TD><TD>49.9</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC320_PV</TD><TD>494.1</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC321_PV</TD><TD>5.79</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC330_PV</TD><TD>401.4</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC331_PV</TD><TD>98.4</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC340_PV</TD><TD>3.1</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC341_PV</TD><TD>2.6</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC350_PV</TD><TD>399.9</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC351_PV</TD><TD>99.9</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC610_PV</TD><TD>7.7</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC620_PV</TD><TD>9.99</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC650_PV</TD><TD>1</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC660_PV</TD><TD>0.5</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC670_PV</TD><TD>0.99</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC690_PV</TD><TD>0.48</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC710_PV</TD><TD>1.46</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC720_PV</TD><TD>0.08</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC730_PV</TD><TD>0.27</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC740_PV</TD><TD>0.09</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC680_PV</TD><TD>0.19</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC780_PV</TD><TD>9.99</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC782_PV</TD><TD>10</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC705_PV</TD><TD>2</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC706_PV</TD><TD>1</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC707_PV</TD><TD>4</TD></TR><TR><TD>7/5/2024 3:11:11 AM</TD><TD>8</TD><TD>3</TD><TD>7623.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC708_PV</TD><TD>3</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC100_PV</TD><TD>1.29</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC101_PV</TD><TD>0.999</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC110_PV</TD><TD>20.3</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC111_PV</TD><TD>10.72</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD><TD>449.9</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC301_PV</TD><TD>50</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC320_PV</TD><TD>494.1</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC321_PV</TD><TD>5.79</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC330_PV</TD><TD>401.4</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC331_PV</TD><TD>98.4</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC340_PV</TD><TD>3</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC341_PV</TD><TD>2.6</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC350_PV</TD><TD>399.9</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC351_PV</TD><TD>99.9</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC610_PV</TD><TD>7.69</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC620_PV</TD><TD>9.99</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC650_PV</TD><TD>1</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC660_PV</TD><TD>0.5</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC670_PV</TD><TD>0.99</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC690_PV</TD><TD>0.479</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC710_PV</TD><TD>1.43</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC720_PV</TD><TD>0.08</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC730_PV</TD><TD>0.28</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC740_PV</TD><TD>0.09</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC680_PV</TD><TD>0.19</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC780_PV</TD><TD>9.99</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC782_PV</TD><TD>9.99</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC705_PV</TD><TD>2</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC706_PV</TD><TD>1</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC707_PV</TD><TD>4</TD></TR><TR><TD>7/5/2024 3:11:12 AM</TD><TD>8</TD><TD>4</TD><TD>7626</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC708_PV</TD><TD>3</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC100_PV</TD><TD>1.29</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC101_PV</TD><TD>0.999</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC110_PV</TD><TD>20</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC111_PV</TD><TD>10.73</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD><TD>449.9</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC301_PV</TD><TD>50</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC320_PV</TD><TD>494.1</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC321_PV</TD><TD>5.79</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC330_PV</TD><TD>401.4</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC331_PV</TD><TD>98.4</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC340_PV</TD><TD>3</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC341_PV</TD><TD>2.6</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC350_PV</TD><TD>399.9</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC351_PV</TD><TD>99.9</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC610_PV</TD><TD>7.69</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC620_PV</TD><TD>9.97</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC650_PV</TD><TD>0.999</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC660_PV</TD><TD>0.5</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC670_PV</TD><TD>0.99</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC690_PV</TD><TD>0.479</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC710_PV</TD><TD>1.41</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC720_PV</TD><TD>0.08</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC730_PV</TD><TD>0.27</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC740_PV</TD><TD>0.09</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC680_PV</TD><TD>0.19</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC780_PV</TD><TD>9.99</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC782_PV</TD><TD>9.99</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC705_PV</TD><TD>1.999</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC706_PV</TD><TD>1</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC707_PV</TD><TD>3.99</TD></TR><TR><TD>7/5/2024 3:11:13 AM</TD><TD>8</TD><TD>5</TD><TD>7627.8</TD><TD>AlN100NM</TD><TD>M1311_ML200</TD><TD>MFC708_PV</TD><TD>3</TD></TR></TBODY></TABLE> Sat, 03 Aug 2024 17:52:22 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4077615#M161912 hannsen13 2024-08-03T17:52:22Z Re: normalise YYYY/MM/DD hh:mm:ss https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4077685#M161917 <LI-CODE lang="markup">Subtract the elapsed time from the first timestamp across all runs, </LI-CODE> <P>None of these words seem to relate to your sample data.&nbsp;Please provide a more detailed explanation of what you are aiming to achieve. What have you tried and where are you stuck?</P> Sat, 03 Aug 2024 18:23:16 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4077685#M161917 lbendlin 2024-08-03T18:23:16Z Re: normalise YYYY/MM/DD hh:mm:ss https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081226#M162012 <P>My end in mind plot will look like this...</P><P><img /></P><P>I am trying to normalised time so I can stacked both legs run at different time with same parameter.</P><P>&nbsp;</P><TABLE><TBODY><TR><TD>DateTime</TD><TD>StepNo</TD><TD>StepTime</TD><TD>StepTotal</TD><TD>StepComment</TD><TD>DOE Leg</TD><TD>Attribute</TD></TR><TR><TD>7/4/2024 8:25:13 PM</TD><TD>10</TD><TD>1</TD><TD>7889.6</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:14 PM</TD><TD>10</TD><TD>2</TD><TD>7891.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:15 PM</TD><TD>10</TD><TD>3</TD><TD>7893.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:16 PM</TD><TD>10</TD><TD>4</TD><TD>7895.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:17 PM</TD><TD>10</TD><TD>5</TD><TD>7897.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:18 PM</TD><TD>10</TD><TD>6</TD><TD>7899.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:19 PM</TD><TD>11</TD><TD>7</TD><TD>7901.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:20 PM</TD><TD>11</TD><TD>1</TD><TD>7903.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:21 PM</TD><TD>11</TD><TD>2</TD><TD>7905.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:22 PM</TD><TD>11</TD><TD>3</TD><TD>7907.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:23 PM</TD><TD>11</TD><TD>4</TD><TD>7909.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:24 PM</TD><TD>11</TD><TD>5</TD><TD>7911.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:25 PM</TD><TD>11</TD><TD>6</TD><TD>7913.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:26 PM</TD><TD>11</TD><TD>7</TD><TD>7915.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:27 PM</TD><TD>11</TD><TD>8</TD><TD>7917.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:28 PM</TD><TD>11</TD><TD>9</TD><TD>7919.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:29 PM</TD><TD>11</TD><TD>10</TD><TD>7921.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:30 PM</TD><TD>11</TD><TD>11</TD><TD>7923.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:31 PM</TD><TD>11</TD><TD>12</TD><TD>7925.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:32 PM</TD><TD>11</TD><TD>13</TD><TD>7927.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:33 PM</TD><TD>11</TD><TD>14</TD><TD>7929.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:35 PM</TD><TD>10</TD><TD>1</TD><TD>7933</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:36 PM</TD><TD>10</TD><TD>2</TD><TD>7934.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:37 PM</TD><TD>10</TD><TD>3</TD><TD>7936.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:38 PM</TD><TD>10</TD><TD>4</TD><TD>7938.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:39 PM</TD><TD>10</TD><TD>5</TD><TD>7940.6</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:40 PM</TD><TD>10</TD><TD>6</TD><TD>7942.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:41 PM</TD><TD>11</TD><TD>7</TD><TD>7944.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:42 PM</TD><TD>11</TD><TD>1</TD><TD>7946.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:43 PM</TD><TD>11</TD><TD>2</TD><TD>7948.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:44 PM</TD><TD>11</TD><TD>3</TD><TD>7950.6</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:45 PM</TD><TD>11</TD><TD>4</TD><TD>7952.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:46 PM</TD><TD>11</TD><TD>5</TD><TD>7954.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:47 PM</TD><TD>11</TD><TD>6</TD><TD>7956.8</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:48 PM</TD><TD>11</TD><TD>7</TD><TD>7958.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:49 PM</TD><TD>11</TD><TD>8</TD><TD>7960.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:50 PM</TD><TD>11</TD><TD>9</TD><TD>7962.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:51 PM</TD><TD>11</TD><TD>10</TD><TD>7964.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:52 PM</TD><TD>11</TD><TD>11</TD><TD>7966.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:53 PM</TD><TD>11</TD><TD>12</TD><TD>7968.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:54 PM</TD><TD>11</TD><TD>13</TD><TD>7970.4</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:55 PM</TD><TD>11</TD><TD>14</TD><TD>7972.2</TD><TD>GaN 20nm</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:56 PM</TD><TD>10</TD><TD>1</TD><TD>7975.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:57 PM</TD><TD>10</TD><TD>2</TD><TD>7977.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:58 PM</TD><TD>10</TD><TD>3</TD><TD>7979.4</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:25:59 PM</TD><TD>10</TD><TD>4</TD><TD>7981.6</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:26:00 PM</TD><TD>10</TD><TD>5</TD><TD>7983.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:26:01 PM</TD><TD>10</TD><TD>6</TD><TD>7985.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/4/2024 8:26:02 PM</TD><TD>10</TD><TD>7</TD><TD>7987.2</TD><TD>AlN5NM</TD><TD>M1313_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:06 AM</TD><TD>10</TD><TD>1</TD><TD>7854</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:07 AM</TD><TD>10</TD><TD>2</TD><TD>7855.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:08 AM</TD><TD>10</TD><TD>3</TD><TD>7857.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:09 AM</TD><TD>10</TD><TD>4</TD><TD>7859.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:10 AM</TD><TD>10</TD><TD>5</TD><TD>7861.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:11 AM</TD><TD>11</TD><TD>1</TD><TD>7865</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:12 AM</TD><TD>11</TD><TD>2</TD><TD>7866.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:13 AM</TD><TD>11</TD><TD>3</TD><TD>7868.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:14 AM</TD><TD>11</TD><TD>4</TD><TD>7871</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:15 AM</TD><TD>11</TD><TD>5</TD><TD>7872.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:16 AM</TD><TD>11</TD><TD>6</TD><TD>7875.2</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:17 AM</TD><TD>11</TD><TD>7</TD><TD>7877</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:18 AM</TD><TD>11</TD><TD>8</TD><TD>7879</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:19 AM</TD><TD>11</TD><TD>9</TD><TD>7880.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:20 AM</TD><TD>11</TD><TD>10</TD><TD>7882.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:21 AM</TD><TD>11</TD><TD>11</TD><TD>7884.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:22 AM</TD><TD>11</TD><TD>12</TD><TD>7886.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:23 AM</TD><TD>11</TD><TD>13</TD><TD>7888.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:24 AM</TD><TD>11</TD><TD>14</TD><TD>7891</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:26 AM</TD><TD>10</TD><TD>1</TD><TD>7894</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:27 AM</TD><TD>10</TD><TD>2</TD><TD>7895.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:28 AM</TD><TD>10</TD><TD>3</TD><TD>7897.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:29 AM</TD><TD>10</TD><TD>4</TD><TD>7899.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:30 AM</TD><TD>10</TD><TD>5</TD><TD>7902</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:31 AM</TD><TD>11</TD><TD>1</TD><TD>7905.2</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:32 AM</TD><TD>11</TD><TD>2</TD><TD>7906.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:33 AM</TD><TD>11</TD><TD>3</TD><TD>7908.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:34 AM</TD><TD>11</TD><TD>4</TD><TD>7910.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:35 AM</TD><TD>11</TD><TD>5</TD><TD>7913</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:36 AM</TD><TD>11</TD><TD>6</TD><TD>7914.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:37 AM</TD><TD>11</TD><TD>7</TD><TD>7916.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:38 AM</TD><TD>11</TD><TD>8</TD><TD>7918.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:39 AM</TD><TD>11</TD><TD>9</TD><TD>7921</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:40 AM</TD><TD>11</TD><TD>10</TD><TD>7923</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:41 AM</TD><TD>11</TD><TD>11</TD><TD>7924.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:42 AM</TD><TD>11</TD><TD>12</TD><TD>7926.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:43 AM</TD><TD>11</TD><TD>13</TD><TD>7929</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:44 AM</TD><TD>11</TD><TD>14</TD><TD>7930.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:46 AM</TD><TD>10</TD><TD>1</TD><TD>7934.4</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:47 AM</TD><TD>10</TD><TD>2</TD><TD>7935.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:48 AM</TD><TD>10</TD><TD>3</TD><TD>7937.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:49 AM</TD><TD>10</TD><TD>4</TD><TD>7939.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:50 AM</TD><TD>10</TD><TD>5</TD><TD>7941.8</TD><TD>AlN5NM</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:51 AM</TD><TD>11</TD><TD>1</TD><TD>7945</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:52 AM</TD><TD>11</TD><TD>2</TD><TD>7947</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:53 AM</TD><TD>11</TD><TD>3</TD><TD>7949</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:54 AM</TD><TD>11</TD><TD>4</TD><TD>7950.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:55 AM</TD><TD>11</TD><TD>5</TD><TD>7952.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:56 AM</TD><TD>11</TD><TD>6</TD><TD>7955</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:57 AM</TD><TD>11</TD><TD>7</TD><TD>7957</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:58 AM</TD><TD>11</TD><TD>8</TD><TD>7959.2</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:13:59 AM</TD><TD>11</TD><TD>9</TD><TD>7960.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:00 AM</TD><TD>11</TD><TD>10</TD><TD>7963</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:01 AM</TD><TD>11</TD><TD>11</TD><TD>7965</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:02 AM</TD><TD>11</TD><TD>12</TD><TD>7966.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:03 AM</TD><TD>11</TD><TD>13</TD><TD>7968.8</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR><TR><TD>7/5/2024 3:14:04 AM</TD><TD>11</TD><TD>14</TD><TD>7971</TD><TD>GaN 20nm</TD><TD>M1311_ML200</TD><TD>MFC300_PV</TD></TR></TBODY></TABLE> Mon, 05 Aug 2024 12:54:55 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081226#M162012 hannsen13 2024-08-05T12:54:55Z Re: normalise YYYY/MM/DD hh:mm:ss https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081244#M162013 <P>What happened to the seconds in your sample data? What's that new MS column doing?</P> Mon, 05 Aug 2024 12:37:10 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081244#M162013 lbendlin 2024-08-05T12:37:10Z Re: normalise YYYY/MM/DD hh:mm:ss https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081293#M162014 <P>I have updated the table.</P><P>My bad. The date time format was changed when I pasted it onto Excel.</P> Mon, 05 Aug 2024 12:56:09 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081293#M162014 hannsen13 2024-08-05T12:56:09Z Re: normalise YYYY/MM/DD hh:mm:ss https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081330#M162015 <P>You can use a calculated column for that.&nbsp;&nbsp;</P> <P>&nbsp;</P> <P><img /></P> <P>&nbsp;</P> Mon, 05 Aug 2024 13:08:54 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/normalise-YYYY-MM-DD-hh-mm-ss/m-p/4081330#M162015 lbendlin 2024-08-05T13:08:54Z