Variável MÊS ATUAL MENOS 13 MESES

[caiqueeloy93]

Boa noite senhores, 

Estou tendo dificuldade em criar uma variável que leia o mês atual e conte 13 meses pra tras, para que eu possa colocar no meu set analyst  por exemplo:

Sum({ $ < [Status Contrato Apresentacao] = {'A3 Área Locada'}, [MesAno] >= {'$(vMes13)'} > } [M2 Instalado])

Alguem pode me ajudar ?

Att

[danilostochi · Accepted solution]

Veja se isso pode lhe atender.

dados:
LOAD * INLINE [

id, valor, status, data
1, 60, A, 01/05/2018
2, 20, A, 02/05/2018
3, 10, I, 03/05/2018
4, 60, A, 04/05/2018
5, 40, I, 05/05/2018
6, 57, A, 06/05/2018
7, "50,66666667", I, 07/05/2018
8, "53,38095238", A, 08/05/2018
9, "56,0952381", I, 09/05/2018
10, "58,80952381", A, 10/05/2018
11, "61,52380952", I, 11/05/2018
12, "64,23809524", A, 12/05/2018
13, "66,95238095", I, 13/05/2018
14, "69,66666667", A, 14/05/2018
15, "72,38095238", I, 15/05/2018
16, "75,0952381", A, 16/05/2018
17, "77,80952381", I, 17/05/2018
18, "80,52380952", A, 18/05/2018
19, "83,23809524", I, 19/05/2018
20, "85,95238095", A, 20/05/2018
21, "88,66666667", I, 21/05/2018
22, "91,38095238", A, 22/05/2018
23, "94,0952381", I, 23/05/2018
24, "96,80952381", A, 24/05/2018
25, "99,52380952", I, 25/05/2018
26, "102,2380952", A, 26/05/2018
27, "104,952381", I, 27/05/2018
28, "107,6666667", A, 28/05/2018
29, "110,3809524", I, 29/05/2018
30, "113,0952381", A, 30/05/2018
31, "115,8095238", I, 31/05/2018
32, "118,5238095", A, 01/06/2018
33, "121,2380952", I, 02/06/2018
34, "123,952381", A, 03/06/2018
35, "126,6666667", I, 04/06/2018
36, "129,3809524", A, 05/06/2018
37, "132,0952381", I, 06/06/2018
38, "134,8095238", A, 07/06/2018
39, "137,5238095", A, 08/06/2018
40, "140,2380952", A, 09/06/2018
41, "142,952381", I, 10/06/2018
42, "145,6666667", A, 11/06/2018
43, "148,3809524", I, 12/06/2018
44, "151,0952381", A, 13/06/2018
45, "153,8095238", I, 14/06/2018
46, "156,5238095", A, 15/06/2018
47, "159,2380952", I, 16/06/2018
48, "161,952381", A, 17/06/2018
49, "164,6666667", I, 18/06/2018
50, "167,3809524", A, 19/06/2018
51, "170,0952381", I, 20/06/2018
52, "172,8095238", A, 21/06/2018
53, "175,5238095", I, 22/06/2018
54, "178,2380952", A, 23/06/2018
55, "180,952381", I, 24/06/2018
56, "183,6666667", A, 25/06/2018
57, "186,3809524", I, 26/06/2018
58, "189,0952381", A, 27/06/2018
59, "191,8095238", I, 28/06/2018
60, "194,5238095", A, 29/06/2018
61, "197,2380952", I, 30/06/2018
62, "199,952381", A, 01/07/2018
63, "202,6666667", I, 02/07/2018
64, "205,3809524", A, 03/07/2018
65, "208,0952381", I, 04/07/2018
66, "210,8095238", A, 05/07/2018
67, "213,5238095", I, 06/07/2018
68, "216,2380952", A, 07/07/2018
69, "218,952381", I, 08/07/2018
70, "221,6666667", A, 09/07/2018
71, "224,3809524", I, 10/07/2018
72, "227,0952381", A, 11/07/2018
73, "229,8095238", I, 12/07/2018
74, "232,5238095", A, 13/07/2018
75, "235,2380952", I, 14/07/2018
76, "237,952381", A, 15/07/2018
77, "240,6666667", I, 16/07/2018
78, "243,3809524", A, 17/07/2018
79, "246,0952381", I, 18/07/2018
80, "248,8095238", A, 19/07/2018
81, "251,5238095", I, 20/07/2018
82, "254,2380952", A, 21/07/2018
83, "256,952381", I, 22/07/2018
84, "259,6666667", A, 23/07/2018
85, "262,3809524", I, 24/07/2018
86, "265,0952381", A, 25/07/2018
87, "267,8095238", I, 26/07/2018
88, "270,5238095", A, 27/07/2018
89, "273,2380952", I, 28/07/2018
90, "275,952381", A, 29/07/2018
91, "278,6666667", I, 30/07/2018
92, "281,3809524", A, 31/07/2018
93, "284,0952381", I, 01/08/2018
94, "286,8095238", A, 02/08/2018
95, "289,5238095", I, 03/08/2018
96, "292,2380952", A, 04/08/2018
97, "294,952381", I, 05/08/2018
98, "297,6666667", A, 06/08/2018
99, "300,3809524", I, 07/08/2018
100, "303,0952381", A, 08/08/2018
101, "305,8095238", I, 09/08/2018
102, "308,5238095", A, 10/08/2018
103, "311,2380952", I, 11/08/2018
104, "313,952381", A, 12/08/2018
105, "316,6666667", I, 13/08/2018
106, "319,3809524", A, 14/08/2018
107, "322,0952381", I, 15/08/2018
108, "324,8095238", A, 16/08/2018
109, "327,5238095", I, 17/08/2018
110, "330,2380952", A, 18/08/2018
111, "332,952381", I, 19/08/2018
112, "335,6666667", A, 20/08/2018
113, "338,3809524", I, 21/08/2018
114, "341,0952381", A, 22/08/2018
115, "343,8095238", I, 23/08/2018
116, "346,5238095", A, 24/08/2018
117, "349,2380952", I, 25/08/2018
118, "351,952381", A, 26/08/2018
119, "354,6666667", I, 27/08/2018
120, "357,3809524", A, 28/08/2018
121, "360,0952381", I, 29/08/2018
122, "362,8095238", A, 30/08/2018
123, "365,5238095", I, 31/08/2018
124, "368,2380952", A, 01/09/2018
125, "370,952381", I, 02/09/2018
126, "373,6666667", A, 03/09/2018
127, "376,3809524", I, 04/09/2018
128, "379,0952381", A, 05/09/2018
129, "381,8095238", I, 06/09/2018
130, "384,5238095", A, 07/09/2018
131, "387,2380952", I, 08/09/2018
132, "389,952381", A, 09/09/2018
133, "392,6666667", I, 10/09/2018
134, "395,3809524", A, 11/09/2018
135, "398,0952381", I, 12/09/2018
136, "400,8095238", A, 13/09/2018
137, "403,5238095", I, 14/09/2018
138, "406,2380952", A, 15/09/2018
139, "408,952381", I, 16/09/2018
140, "411,6666667", A, 17/09/2018
141, "414,3809524", I, 18/09/2018
142, "417,0952381", A, 19/09/2018
143, "419,8095238", I, 20/09/2018
144, "422,5238095", A, 21/09/2018
145, "425,2380952", I, 22/09/2018
146, "427,952381", A, 23/09/2018
147, "430,6666667", I, 24/09/2018
148, "433,3809524", A, 25/09/2018
149, "436,0952381", I, 26/09/2018
150, "438,8095238", A, 27/09/2018
151, "441,5238095", I, 28/09/2018
152, "444,2380952", A, 29/09/2018
153, "446,952381", I, 30/09/2018
154, "449,6666667", A, 01/10/2018
155, "452,3809524", I, 02/10/2018
156, "455,0952381", A, 03/10/2018
157, "457,8095238", I, 04/10/2018
158, "460,5238095", A, 05/10/2018
159, "463,2380952", I, 06/10/2018
160, "465,952381", A, 07/10/2018
161, "468,6666667", I, 08/10/2018
162, "471,3809524", A, 09/10/2018
163, "474,0952381", I, 10/10/2018
164, "476,8095238", A, 11/10/2018
165, "479,5238095", I, 12/10/2018
166, "482,2380952", A, 13/10/2018
167, "484,952381", I, 14/10/2018
168, "487,6666667", A, 15/10/2018
169, "490,3809524", I, 16/10/2018
170, "493,0952381", A, 17/10/2018
171, "495,8095238", I, 18/10/2018
172, "498,5238095", A, 19/10/2018
173, "501,2380952", I, 20/10/2018
174, "503,952381", A, 21/10/2018
175, "506,6666667", I, 22/10/2018
176, "509,3809524", A, 23/10/2018
177, "512,0952381", I, 24/10/2018
178, "514,8095238", A, 25/10/2018
179, "517,5238095", I, 26/10/2018
180, "520,2380952", A, 27/10/2018
181, "522,952381", I, 28/10/2018
182, "525,6666667", A, 29/10/2018
183, "528,3809524", I, 30/10/2018
184, "531,0952381", A, 31/10/2018
185, "533,8095238", I, 01/11/2018
186, "536,5238095", A, 02/11/2018
187, "539,2380952", I, 03/11/2018
188, "541,952381", A, 04/11/2018
189, "544,6666667", I, 05/11/2018
190, "547,3809524", A, 06/11/2018
191, "550,0952381", I, 07/11/2018
192, "552,8095238", A, 08/11/2018
193, "555,5238095", I, 09/11/2018
194, "558,2380952", A, 10/11/2018
195, "560,952381", I, 11/11/2018
196, "563,6666667", A, 12/11/2018
197, "566,3809524", I, 13/11/2018
198, "569,0952381", A, 14/11/2018
199, "571,8095238", I, 15/11/2018
200, "574,5238095", A, 16/11/2018
201, "577,2380952", I, 17/11/2018
202, "579,952381", A, 18/11/2018
203, "582,6666667", I, 19/11/2018
204, "585,3809524", A, 20/11/2018
205, "588,0952381", I, 21/11/2018
206, "590,8095238", A, 22/11/2018
207, "593,5238095", I, 23/11/2018
208, "596,2380952", A, 24/11/2018
209, "598,952381", I, 25/11/2018
210, "601,6666667", A, 26/11/2018
211, "604,3809524", I, 27/11/2018
212, "607,0952381", A, 28/11/2018
213, "609,8095238", I, 29/11/2018
214, "612,5238095", A, 30/11/2018
215, "615,2380952", I, 01/12/2018
216, "617,952381", A, 02/12/2018
217, "620,6666667", I, 03/12/2018
218, "623,3809524", A, 04/12/2018
219, "626,0952381", I, 05/12/2018
220, "628,8095238", A, 06/12/2018
221, "631,5238095", I, 07/12/2018
222, "634,2380952", A, 08/12/2018
223, "636,952381", I, 09/12/2018
224, "639,6666667", A, 10/12/2018
225, "642,3809524", I, 11/12/2018
226, "645,0952381", A, 12/12/2018
227, "647,8095238", I, 13/12/2018
228, "650,5238095", A, 14/12/2018
229, "653,2380952", I, 15/12/2018
230, "655,952381", A, 16/12/2018
231, "658,6666667", I, 17/12/2018
232, "661,3809524", A, 18/12/2018
233, "664,0952381", I, 19/12/2018
234, "666,8095238", A, 20/12/2018
235, "669,5238095", I, 21/12/2018
236, "672,2380952", A, 22/12/2018
237, "674,952381", I, 23/12/2018
238, "677,6666667", A, 24/12/2018
239, "680,3809524", I, 25/12/2018
240, "683,0952381", A, 26/12/2018
241, "685,8095238", I, 27/12/2018
242, "688,5238095", A, 28/12/2018
243, "691,2380952", I, 29/12/2018
244, "693,952381", A, 30/12/2018
245, "696,6666667", I, 31/12/2018
246, "699,3809524", A, 01/01/2019
247, "702,0952381", I, 02/01/2019
248, "704,8095238", A, 03/01/2019
249, "707,5238095", I, 04/01/2019
250, "710,2380952", A, 05/01/2019
251, "712,952381", I, 06/01/2019
252, "715,6666667", A, 07/01/2019
253, "718,3809524", I, 08/01/2019
254, "721,0952381", A, 09/01/2019
255, "723,8095238", I, 10/01/2019
256, "726,5238095", A, 11/01/2019
257, "729,2380952", I, 12/01/2019
258, "731,952381", A, 13/01/2019
259, "734,6666667", I, 14/01/2019
260, "737,3809524", A, 15/01/2019
261, "740,0952381", I, 16/01/2019
262, "742,8095238", A, 17/01/2019
263, "745,5238095", I, 18/01/2019
264, "748,2380952", A, 19/01/2019
265, "750,952381", I, 20/01/2019
266, "753,6666667", A, 21/01/2019
267, "756,3809524", I, 22/01/2019
268, "759,0952381", A, 23/01/2019
269, "761,8095238", I, 24/01/2019
270, "764,5238095", A, 25/01/2019
271, "767,2380952", I, 26/01/2019
272, "769,952381", A, 27/01/2019
273, "772,6666667", I, 28/01/2019
274, "775,3809524", A, 29/01/2019
275, "778,0952381", I, 30/01/2019
276, "780,8095238", A, 31/01/2019
277, "783,5238095", I, 01/02/2019
278, "786,2380952", A, 02/02/2019
279, "788,952381", I, 03/02/2019
280, "791,6666667", A, 04/02/2019
281, "794,3809524", I, 05/02/2019
282, "797,0952381", A, 06/02/2019
283, "799,8095238", I, 07/02/2019
284, "802,5238095", A, 08/02/2019
285, "805,2380952", I, 09/02/2019
286, "807,952381", A, 10/02/2019
287, "810,6666667", I, 11/02/2019
288, "813,3809524", A, 12/02/2019
289, "816,0952381", I, 13/02/2019
290, "818,8095238", A, 14/02/2019
291, "821,5238095", I, 15/02/2019
292, "824,2380952", A, 16/02/2019
293, "826,952381", I, 17/02/2019
294, "829,6666667", A, 18/02/2019
295, "832,3809524", I, 19/02/2019
296, "835,0952381", A, 20/02/2019
297, "837,8095238", I, 21/02/2019
298, "840,5238095", A, 22/02/2019
299, "843,2380952", I, 23/02/2019
300, "845,952381", A, 24/02/2019
301, "848,6666667", I, 25/02/2019
302, "851,3809524", A, 26/02/2019
303, "854,0952381", I, 27/02/2019
304, "856,8095238", A, 28/02/2019
305, "859,5238095", I, 01/03/2019
306, "862,2380952", A, 02/03/2019
307, "864,952381", I, 03/03/2019
308, "867,6666667", A, 04/03/2019
309, "870,3809524", I, 05/03/2019
310, "873,0952381", A, 06/03/2019
311, "875,8095238", I, 07/03/2019
312, "878,5238095", A, 08/03/2019
313, "881,2380952", I, 09/03/2019
314, "883,952381", A, 10/03/2019
315, "886,6666667", I, 11/03/2019
316, "889,3809524", A, 12/03/2019
317, "892,0952381", I, 13/03/2019
318, "894,8095238", A, 14/03/2019
319, "897,5238095", I, 15/03/2019
320, "900,2380952", A, 16/03/2019
321, "902,952381", I, 17/03/2019
322, "905,6666667", A, 18/03/2019
323, "908,3809524", I, 19/03/2019
324, "911,0952381", A, 20/03/2019
325, "913,8095238", I, 21/03/2019
326, "916,5238095", A, 22/03/2019
327, "919,2380952", I, 23/03/2019
328, "921,952381", A, 24/03/2019
329, "924,6666667", I, 25/03/2019
330, "927,3809524", A, 26/03/2019
331, "930,0952381", I, 27/03/2019
332, "932,8095238", A, 28/03/2019
333, "935,5238095", I, 29/03/2019
334, "938,2380952", A, 30/03/2019
335, "940,952381", I, 31/03/2019
336, "943,6666667", A, 01/04/2019
337, "946,3809524", I, 02/04/2019
338, "949,0952381", A, 03/04/2019
339, "951,8095238", I, 04/04/2019
340, "954,5238095", A, 05/04/2019
341, "957,2380952", I, 06/04/2019
342, "959,952381", A, 07/04/2019
343, "962,6666667", I, 08/04/2019
344, "965,3809524", A, 09/04/2019
345, "968,0952381", I, 10/04/2019
346, "970,8095238", A, 11/04/2019
347, "973,5238095", I, 12/04/2019
348, "976,2380952", A, 13/04/2019
349, "978,952381", I, 14/04/2019
350, "981,6666667", A, 15/04/2019
351, "984,3809524", I, 16/04/2019
352, "987,0952381", A, 17/04/2019
353, "989,8095238", I, 18/04/2019
354, "992,5238095", A, 19/04/2019
355, "995,2380952", I, 20/04/2019
356, "997,952381", A, 21/04/2019
357, "1000,666667", I, 22/04/2019
358, "1003,380952", A, 23/04/2019
359, "1006,095238", I, 24/04/2019
360, "1008,809524", A, 25/04/2019
361, "1011,52381", I, 26/04/2019
362, "1014,238095", A, 27/04/2019
363, "1016,952381", I, 28/04/2019
364, "1019,666667", A, 29/04/2019
365, "1022,380952", I, 30/04/2019
366, "1025,095238", A, 01/05/2019
367, "1027,809524", I, 02/05/2019
368, "1030,52381", A, 03/05/2019
369, "1033,238095", I, 04/05/2019
370, "1035,952381", A, 05/05/2019
371, "1038,666667", I, 06/05/2019
372, "1041,380952", A, 07/05/2019
373, "1044,095238", I, 08/05/2019
374, "1046,809524", A, 09/05/2019
375, "1049,52381", I, 10/05/2019
376, "1052,238095", A, 11/05/2019
377, "1054,952381", I, 12/05/2019
378, "1057,666667", A, 13/05/2019
379, "1060,380952", I, 14/05/2019
380, "1063,095238", A, 15/05/2019
381, "1065,809524", I, 16/05/2019
382, "1068,52381", A, 17/05/2019
383, "1071,238095", I, 18/05/2019
384, "1073,952381", A, 19/05/2019
385, "1076,666667", I, 20/05/2019
386, "1079,380952", A, 21/05/2019
387, "1082,095238", I, 22/05/2019
388, "1084,809524", A, 23/05/2019
389, "1087,52381", I, 24/05/2019
390, "1090,238095", A, 25/05/2019
391, "1092,952381", I, 26/05/2019
392, "1095,666667", A, 27/05/2019
393, "1098,380952", I, 28/05/2019
394, "1101,095238", A, 29/05/2019
395, "1103,809524", I, 30/05/2019
396, "1106,52381", A, 31/05/2019
397, "1109,238095", I, 01/06/2019
398, "1111,952381", A, 02/06/2019
399, "1114,666667", I, 03/06/2019
400, "1117,380952", A, 04/06/2019
401, "1120,095238", I, 05/06/2019
402, "1122,809524", A, 06/06/2019
403, "1125,52381", I, 07/06/2019
404, "1128,238095", A, 08/06/2019
405, "1130,952381", I, 09/06/2019
406, "1133,666667", A, 10/06/2019
407, "1136,380952", I, 11/06/2019
408, "1139,095238", A, 12/06/2019
409, "1141,809524", I, 13/06/2019
410, "1144,52381", A, 14/06/2019
411, "1147,238095", I, 15/06/2019
412, "1149,952381", A, 16/06/2019
413, "1152,666667", I, 17/06/2019
414, "1155,380952", A, 18/06/2019
415, "1158,095238", I, 19/06/2019
416, "1160,809524", A, 20/06/2019
417, "1163,52381", I, 21/06/2019
418, "1166,238095", A, 22/06/2019
419, "1168,952381", I, 23/06/2019
420, "1171,666667", A, 24/06/2019
421, "1174,380952", I, 25/06/2019
422, "1177,095238", A, 26/06/2019
423, "1179,809524", I, 27/06/2019
424, "1182,52381", A, 28/06/2019
425, "1185,238095", I, 29/06/2019
426, "1187,952381", A, 30/06/2019
427, "1190,666667", I, 01/07/2019
428, "1193,380952", A, 02/07/2019
429, "1196,095238", I, 03/07/2019
430, "1198,809524", A, 04/07/2019
431, "1201,52381", I, 05/07/2019
432, "1204,238095", A, 06/07/2019
433, "1206,952381", I, 07/07/2019
434, "1209,666667", A, 08/07/2019
];

//Set Analysis deixando o mesmo dia mas somente -13 meses 

=Sum({$<data={"$(=date(AddMonths(max(data),-13)))"}, status={'A'}>}valor)

//Set Analysis do período -13 meses

=Sum({$<data={">=$(=Date(MonthStart(Max(data),-13)))<=$(=Date(MonthEnd(date(Max(data)),-13)))"}, status={'A'}>}valor)