A directional trend is a simple time series data analysis technique to imply a relative direction of performance. The main attribute of this technique is that is a set of calculated values as opposed to actual data values. Many thanks to legends: John Walkenbach and Michael Alexander aka "DataPig" for sharing this hidden gem technique of Directional Trending for their masterpiece book: Excel Dashboards and Reports.
You can download the pbix file below. Feel free to poke it.
eyJrIjoiYWI3ZGI1YzQtNGRlMy00NWFlLTllNDYtMTNkNjViZjNmMWRkIiwidCI6IjEwZWM3OTJjLTU4NzctNGU1ZS05OGE5LTFiMWQ3YTNjM2RlYiIsImMiOjR9
