Forum Discussion
Power BI Script
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 co...
| 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 |
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.