Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
76
Views
Topic starter
Hi,
In following table, asset no. 10001 is disposed on 1/13/2019. I want to fill up this date (upto 8/1/2018) in date of disposal column only for asset no. 10001. Is there any way in power query to achieve this? Please help..
Thank you!!
Kind Regards
Arun
| Transaction date | Asset No | Date of Acquistion | Date of disposal | Acquisition amount | Repair | Service | Other expense | Disposal Amount |
| 1/1/2018 | 10000 | 1/1/2018 | $6,000 | |||||
| 2/1/2018 | 10000 | 1/1/2018 | $300 | |||||
| 3/1/2018 | 10000 | 1/1/2018 | $400 | |||||
| 4/1/2018 | 10000 | 1/1/2018 | $500 | |||||
| 5/1/2018 | 10000 | 1/1/2018 | $200 | |||||
| 6/1/2018 | 10000 | 1/1/2018 | $300 | |||||
| 7/1/2018 | 10000 | 1/1/2018 | $500 | |||||
| 8/1/2018 | 10001 | 8/1/2018 | $5,000 | |||||
| 9/1/2018 | 10001 | 8/1/2018 | $200 | |||||
| 10/1/2018 | 10001 | 8/1/2018 | $300 | |||||
| 11/1/2018 | 10001 | 8/1/2018 | $700 | |||||
| 12/1/2018 | 10001 | 8/1/2018 | $200 | |||||
| 1/13/2019 | 10001 | 8/1/2018 | 1/13/2019 | $1,000 |
Posted : 21/06/2018 5:56 am
Hi Arun,
You can create another query that contains just the disposal dates. Then merge this query with your original data to bring in the disposal date for every row. See example file attached.
Mynda
Posted : 21/06/2018 7:19 am
Topic starter
Thank you so much Mynda...
Posted : 22/06/2018 5:10 am
