Find my approach as reference below and stored in attached workbook version 10.2 located in the original thread
1. M1. Last 12 month: if DATEDIFF('month',[Date],today())>1 and DATEDIFF('month',[Date],today())<=14 then [Volume] END
Sample_nalmai_10.2.twbx 87.5 KB
Iám glad yopu coulkd answer this one,
But I'm also looking for an adjustment.
I hav a Bar-graph over the last six months.
I'd liked to show a constant regference line based on the average of the 12 months prior to the six wich are shown in the graph.
how do I have tot modify you formula?
Kind regards Noud