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...
| Date | Year | Month | Month Name | Quarter | Start of Month | Fiscal Month | Fiscal Quarter | Fiscal Year |
| 7/1/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/2/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/3/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/4/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/5/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/6/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/7/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/8/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |
| 7/9/2020 | 2020 | 7 | Jul | 3 | 7/1/2020 | 4 | 2 | 2021 |