New to Power Bi - Need to add column with date when status changes

[shawncummins]

Hello,

I am trying to track the date when status changes past a certain value. For example, my statuses range from 90-900, I want power bi to calculate the day in a column named "Date Packed" when my status changes above 401. How do I do this? 

[v-zhangti]

Hi, @shawncummins 

Can you provide more sample data for testing? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures or Excel.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[shawncummins]

So I am trying to figure out how many units we have packed out. The issue is the status for packing is 400 and 401, and I have statuses that come afterwards. I am just wanting to copy the time stamp and paste in a new column to capture when the order status is greater than 401. You can see below, I have order #, status, and the time stamp. The issue is, the time stamp updates when status changes, so I just want to capture it when the action occurs.

[shawncummins]

	erp_order	status1	DATE_TIME_STAMP
	26929156	100	3/13/23 5:08 PM
	26251152	100	3/17/23 2:03 PM
	26251152	100	3/17/23 2:03 PM
	26251152	100	3/17/23 2:03 PM
	27396226	200	4/20/23 5:20 PM
	27396226	200	4/20/23 5:20 PM
	27396226	200	4/20/23 5:20 PM
	27396226	200	4/20/23 5:20 PM
	27396226	200	4/20/23 5:20 PM
	27325758	300	4/19/23 5:44 PM
	27391807	300	4/19/23 7:47 PM
	27391807	300	4/19/23 7:47 PM
	27391807	300	4/19/23 7:47 PM
	27391807	300	4/19/23 7:47 PM
	27391807	300	4/19/23 7:47 PM
	27391807	300	4/19/23 7:47 PM
	27391807	300	4/19/23 7:47 PM
	27469501	400	4/20/23 7:58 PM
	27469501	400	4/20/23 7:58 PM
	27469501	400	4/20/23 7:58 PM
	27469501	400	4/20/23 7:58 PM
	27452749	401	4/20/23 8:03 PM
	27452749	401	4/20/23 8:03 PM
	27452749	401	4/20/23 8:03 PM
	27452749	401	4/20/23 8:03 PM
	27452749	401	4/20/23 8:03 PM
	27452749	401	4/20/23 8:03 PM
	27452749	401	4/20/23 8:03 PM
	27464656	401	4/20/23 7:52 PM
	27459770	401	4/20/23 7:39 PM
	27464656	401	4/20/23 7:52 PM
	27464656	401	4/20/23 7:44 PM
	27459770	401	4/20/23 7:39 PM
	27459770	401	4/20/23 7:39 PM
	27443263	401	4/20/23 7:48 PM
	27443263	401	4/20/23 7:48 PM
	26907470	600	4/19/23 3:49 PM
	26908045	600	4/18/23 4:07 PM
	26908045	600	4/18/23 4:07 PM
	26908045	600	4/18/23 4:07 PM
	26908045	600	4/18/23 4:07 PM
	26908046	600	4/18/23 4:07 PM
	26908046	600	4/18/23 4:07 PM
	26908046	600	4/18/23 4:07 PM
	26908046	600	4/18/23 4:07 PM
	26907475	600	4/18/23 4:17 PM
	24117034	700	9/15/22 4:36 AM
	27180372	700	3/30/23 1:42 PM
	27180372	700	3/30/23 1:42 PM
	27180372	700	3/30/23 1:42 PM
	27324801	700	4/20/23 3:03 PM
	25840700	900	4/6/23 4:58 PM
	25840700	900	4/6/23 4:58 PM
	25840700	900	4/6/23 4:58 PM
	25840700	900	4/6/23 4:58 PM
	25840700	900	4/6/23 4:58 PM
	25840700	900	4/6/23 4:58 PM
	25840700	900	4/6/23 4:58 PM

[v-zhangti · Accepted solution]

Hi, @shawncummins 

Which of the following is your expected output?

Column = IF([status1]>401,[DATE_TIME_STAMP])

Measure = CALCULATE(COUNT('Table'[erp_order]),FILTER(ALL('Table'),[status1]>401))

If neither, please tell us what output you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.