Forum Discussion
Calculated Column as Day Counter Until Values Match in Different Rows
I want to create a calculated column which acts as a day counter using Today() - Schedule Date next to the fill_id column until all the status_desc changes to "Finished" where fill_id = parent_fill_id. Please help.
| Lot # | fill_id | parent_fill_id | Schedule Date | status_desc |
| TC8003 | D21A051B-624D-49A0-9BA4-4735092EBF77 | 10/5/2018 0:00 | Finished | |
| TC8003A | 0069E5F2-72D7-4329-9177-E249EC4FBCA1 | D21A051B-624D-49A0-9BA4-4735092EBF77 | 10/5/2018 0:00 | Finished |
| TC8003B | ADC19E46-1269-4C9F-933A-58076FDE7B1E | D21A051B-624D-49A0-9BA4-4735092EBF77 | 10/5/2018 0:00 | Finished |
| TC8003C | A425A2E9-B5CC-401C-9512-EBF82CC836B4 | D21A051B-624D-49A0-9BA4-4735092EBF77 | 10/5/2018 0:00 | Finished |
| TC8004 | DD6652BC-623D-44D0-9FD8-C1A2CBCC40F8 | 10/18/2018 0:00 | Finished | |
| TC8004A | 227A83CA-DBAB-4EC3-95FA-D2FADC99583A | DD6652BC-623D-44D0-9FD8-C1A2CBCC40F8 | 10/19/2018 0:00 | Finished |
| TC8004B | 7E2414D4-B21D-4C59-AA28-B228A89747DE | DD6652BC-623D-44D0-9FD8-C1A2CBCC40F8 | 10/19/2018 0:00 | Finished |
| TC8004C | 9658A238-9915-454A-B880-A8DD2574D283 | DD6652BC-623D-44D0-9FD8-C1A2CBCC40F8 | 10/19/2018 0:00 | Finished |
| TC8005 | FEEC4480-FF01-4C5E-90F1-3E2F0F15C9F7 | 12/10/2018 0:00 | Finished | |
| TC8005A | DD65D302-B7E1-4EA0-A026-84EBBB4FC451 | FEEC4480-FF01-4C5E-90F1-3E2F0F15C9F7 | 12/10/2018 0:00 | Confirmed |
| TC8005B | 968479F6-E711-4902-A892-8939ED527332 | FEEC4480-FF01-4C5E-90F1-3E2F0F15C9F7 | 12/10/2018 0:00 | Confirmed |
| TC8005C | 005596CF-E71F-4B92-8326-17196F640CD6 | FEEC4480-FF01-4C5E-90F1-3E2F0F15C9F7 | 12/11/2018 0:00 | Confirmed |
| TC8006 | 900F6CA3-ADDA-4305-A589-F8D969779ADD | 12/11/2018 0:00 | Finished | |
| TC8006A | FBF5D66F-08C9-4243-963C-BA7034458559 | 900F6CA3-ADDA-4305-A589-F8D969779ADD | 12/11/2018 0:00 | Confirmed |
| TC8006B | 834EE686-D95A-4A62-881B-206741D4CE10 | 900F6CA3-ADDA-4305-A589-F8D969779ADD | 12/11/2018 0:00 | Confirmed |
| TC8006C | 018E8252-E72C-4E11-A909-2A698DE9BBE1 | 900F6CA3-ADDA-4305-A589-F8D969779ADD | 12/11/2018 0:00 | Confirmed |
5 Replies
See if this gets you in the right direction. Below is the pbix file where you can see all the steps in Power Query on how I got to that column:
Pbix file:
No it doesn't.
To clarify, I want the day counter to continue, say for TC8005 (parent), until the point status_desc for TC8005A, TC8005B and TC8005C (children) turns to "Finished". Once all parent and children turn to "Finished" then day counter should go blank.
