Forum Discussion
Asset Depreciation Forecast - custom function
Hi folks, I am relatively new to Power Query and trying to simulate straightline depreciation for my assets (50k assets) in Excel. Since the dataset is big and assets are added every month I am u...
| Asset | Sub-number | Depreciation Calculation Start Date | Life | Cumul.acq.value | Currency |
| 32100022222 | 0 | 1/1/2013 | 020/000 | 47,189.18 | EUR |
| 32100012345 | 0 | 1/1/2013 | 018/000 | 3,731.77 | EUR |
| 32100012345 | 1 | 1/1/2013 | 020/005 | 6,717.73 | EUR |
| 32100012345 | 2 | 1/1/2013 | 020/000 | 147,671.87 | EUR |
| 32100044444 | 0 | 1/1/2012 | 005/001 | 13,317.33 | EUR |
| 32100044444 | 1 | 1/1/2012 | 005/001 | 9,761.00 | EUR |
| 32114560061 | 0 | 1/1/2012 | 000/001 | 188.43 | EUR |
| 32123456007 | 0 | 1/1/2012 | 000/001 | 83.73 | EUR |
| 32123456008 | 0 | 1/1/2012 | 005/001 | 3,736.84 | EUR |