Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 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).

Need Help

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago
    Serial NumberAsset KeyDEPRN_START_DATELIFE_IN_MONTHSADJUSTED_COSTCOSTORIGINAL_COSTSALVAGE_VALUE Years to date31-Mar-21  Depreciation Calculation
     NONE31/10/202036038270843.23191354216.219709648915308337338270843                5.03      354.97  1,467,103.87 ((ORIGINAL_COST-SALVAGE VALUE)/NO.OF MONTHS)*12
    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      My expected output is the formula written there

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Super User
      3 years ago

      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.