Using the data in the file you sent. As per the first post in this trail I'm using POWER BI I've recreated all the queries within Power BI - but ...
All seems to be working - thank you. However, now that we have created a line for each year of a contract eg a 5 year contract now has 5 lines ins...
Thank you
Hi Its in Part 2 Linking Financial Statements - Working Capital Adjustments - A Complicated Example I've not found a workbook with this example ...
Will it have to be another IF scenario for expired and Unexpired contracts that duplicates what we have already but with the additional && cri...
Thank you. The Ctrl C Ctrl V doesn’t appear to work once you open the format cell box?
Thanks. It appears There’s just one more little quirk for contracts that expire in the future I need to also check their status as being activ...
Thank you