I have a unique scenario where I need to Forecast Fixed Asset Depreciation across the life of the asset. Below are the details:
An asset is acquired on a particular date i.e. 2019-06-20 and service life is 2 years, so the endDate of the asset will be 2019-06-20 + 2 years i.e. 2021-06-20. I need to divide the depreciation value across these month for each asset, acquisition date and enddate of each asset may be different.
This is required in Power BI Direct Query mode.
Your support will be appreciated.