In this table I have the average elapsed time of the different Workbooks for every month. (Dimensions Workbook and Month, Measure Average Elapsed Time). The data is gathered from the example Query Detail table I posted.
I would like to get the following:
Adding a column in this table with only two outputs available for each Workbook:
1- POSITIVE: When the trend over the month is decreasing, negative
2- NEGATIVE: When the trend over the month is increasing, positive