Forum Discussion
Helper IIICalculating 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 reduce until it hits 0. I have different products and product families that I want as my rows on a pivot table and the dates as the columns but I can't seem to figure this out for whatever reason.
Can someone provide some general DAX help for this? My depreciation is linear and essentially based on "Value - (Residual Value/Lifespan)
Let me know if more information is needed. I feel dumb asking this as it should be a simple fix.
7 Replies
seanprattThanks 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
- seanpratt
Bump.
Any help on this, please? Been trying variations all day. I basically just need to show a repeating deprecation value between (Start Date) and (End Date).
Please help
- seanpratt
Here it is. Setting the depreciation value as standard value - ((1-resid.)/(useful)
I've been then using the depreciation value and dividing by 12 months to get a monthly total but not sure if I should be doing that.
- fhill
Resident Rockstar
Is this what you had in mind? If so, i'll add more details, I took a table of Description, Start Month, & # of Month to LIST all months per Item, and calculate the remaining value each month until them item zeros out.
