Forum Discussion
lukeSDM
5 years agoHelper V
Calculating the difference between different rows with a common subject
Hi All, I am looking to calculate the difference between the grades , between the result sets for each aspect. So for 'Jim' I want to calculate the difference between his target and in autumn , ...
BA_Pete
5 years agoSuper User
Hi lukeSDM ,
Could you provide a basic example of what you want your end result to be please?
What type of visualisations are you going to use, will it always only be Spring and Autumn or Winter and Summer too, are the seasons/terms always compared to a single target value or can you have seasonal targets, can you use Power Query, are you using Direct Query?
Pete