Power BI Script

[Anonymous]

Please assist with a script to calculate depreciation using Power BI DAX. For example, I have an asset with a cost value of $10000, salvage value $1000, Acquisition date 10.09.2021. I also want to consider if l was auditing the current financial year starting 10.07.2021, how can l calculate depreciation for those 2 months within the financial year(12months).

[Anonymous]

Serial Number

Asset Key

DEPRN_START_DATE

LIFE_IN_MONTHS

ADJUSTED_COST

COST

ORIGINAL_COST

SALVAGE_VALUE

Years to date

31-Mar-21

Depreciation Calculation

NONE

31/10/2020

360

38270843.23

191354216.2

197096489

153083373

38270843

5.03

354.97

1,467,103.87

((ORIGINAL_COST-SALVAGE VALUE)/NO.OF MONTHS)*12

[Ashish_Mathur]

Hi,

Your data does not paste properly in MS Excel.  Please share the download link of your MS Excel file with a few line items (rather than just one).  Also, how can the FY start from 10.07.2021?  Please share the starting month of the FY.

[Anonymous]

My expected output is the formula written there

[Ashish_Mathur]

Hi,

Share a few rows of data (in a format that can be pasted in an MS Excel file) and shwo the expected result.