Forum Discussion
Investment needed over time.
Hi all,
From the table below how can I look at how an asset performs over time and want to see how the investment needed changes over 30 years.
The table shows Property ID by planned maintenance (investment) where we only have value for this year window.
This is how I would like to see it.
Many thanks in advance.
R
Hi Anonymous ,
Try this. https://drive.google.com/file/d/1Zo3On7dQ_BOiI2nq5sIWkfSsGej0D6y8/view?usp=sharing
If there is anything else, let me know. If it meets your needs, please accept my answer.
4 Replies
Hi Anonymous ,
Try this. https://drive.google.com/file/d/1Zo3On7dQ_BOiI2nq5sIWkfSsGej0D6y8/view?usp=sharing
If there is anything else, let me know. If it meets your needs, please accept my answer.
Thanks, davehus
I can see that your values come from the same field, but in my data source, they come from different columns, unfortunately.
That said, it's not possible to recreate what you did, isn't it?Thanks,
Renata
Hi Renata, The report is built off the same format as your example, If you click through the transformation steps in Power Query it will show you what's happening to the data.
You just need to change the sample data for your own.
The data is unpivoted into a table and a conditional column is added to give the year end for each year you require.
Dave