Forum Discussion
Find changes in trend
In statistics, a moving average is the most frequently used way to identify trends with smoothing out short-term fluctuations. With PBI, it's even more informative by visulizing it.
i_like_tacos - You don't really need to implement any complicated DAX for this. You could do so with the right choice of visualisation. Customising a Scatter Plot would help visualise changes to the norm for each student.
This is a great article that will show you how: https://www.sqlbi.com/articles/using-scatterplots-to-find-details-in-reports/
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!
i_like_tacos - You don't really need to implement any complicated DAX for this. You could do so with the right choice of visualisation. Customising a Scatter Plot would help visualise changes to the norm for each student.
This is a great article that will show you how: https://www.sqlbi.com/articles/using-scatterplots-to-find-details-in-reports/
If I answered your question please mark my post as the solution, it helps others with the same challenge find the answer!