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.
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!
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.
Hello, I would like to see your solution if possible? I have the same issue, but also trying to figure out one more problem on top of the depriciation, which is how much is the depreciation in the last year before going to 0.
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.
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).
Check out new user group experience and if you are a leader please create your group
Click here to read more about the April 2021 Updates!
100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.
See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.