Forum Discussion

seanpratt's avatar
seanpratt
Icon for Helper III rankHelper III
6 years ago

Calculating Depreciation in DAX

I'm having a rough time doing something fairly simple, or at least I'd think it was simple.  I simply need to see the value of products reduce monthly in a pivot table. I want to see that value ...
Need Help
Tips and Tricks
seanpratt's avatar
seanpratt
Icon for Helper III rankHelper III
6 years ago

Thanks so much to all who checked in. I actually solved the answer by scouring the internet. Turns out it was turning those basic tables into a fleshed out table through PowerQuery and then it was pretty quick with a couple of DAX formulas after.

 

This wasn't the exact situation but the same logic applies. Leaving this link here in case anyone ever needs it!

 

https://forum.enterprisedna.co/t/create-amortization-table/2404

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

    The link can not be openned.

    Could you pls. share some details on the logic and dax formula?

    Thanks.