Hello everyone,
I need to create a trend line with dimension [Year Month] interval YTD (jan to current month) and for each month i have to calculate the nine month before. I have already created thi graph with this measure:
Rangesum(above(count(Transaction),9)) and the formula works correctly if I don't apply any filter. The problem is that my dimension have to be a YTD so from January to current month but with this formulas January not include the nine month before.
How can i do?
Thanks a lot!