Measures to create dynamic visualisation that changes based on two run dates selected in filter

Anonymous The recommendation is to create a data model and to normalize your one big table into reasonable dimension and fact tables. Dimension tables could be the calendar, the Owner/Person table, the Account table etc, and the fact table could be the amount and code.  

With that in place you will be able to use the standard DAX functions for time intelligence. The Quick measures also give you a great starting point for these patterns.