Forum Discussion
Conditional formatting based on Conversion measure - previous year
Anonymous
To be able to do time calculations using the standard time-intel functions (and it looks like this could be what you need) you have to create a Date table and relate it to the fact table. The Date table must be created the way that, for instance, this article describes: https://dax.guide/dateadd
Once you have such a table, you can create a measure that will return ±1 depending on the increase/decrease in the measure from one period to another. Since you're using Academic Years the table will have to feature a column that will store consecutive numbers for these years so that you are able to move forward and back within these years in the DAX code. If you want to see how to calculate deltas between the current and the prior period, you can read this: