Filter dates

[RafaelAri]

Hello,

I have a table of warehouse content, with "Last Transaction Date" column.

I want to add column that gives "1" for dates from more than 24 months ago and "0" for dates in the last 24 months.

I used Date.IsInPreviousNMonths but I get strange results.

See part of the table here:

Item No.	Last Trans.	Previous to 24 months ago
A1126	31/12/21	1
A1127	31/12/21	1
A1128	31/12/18	0
A1129	31/12/21	1
A1130	31/12/21	1
A1131	31/12/18	0
A1132	31/12/18	0
A1145	31/12/18	0
A1146	31/12/21	1
A1147	31/12/21	1
A1148	31/12/21	1
A1149	31/12/21	1
A1150	31/12/21	1
A1151	31/12/21	1
A1152	31/12/21	1
A1153	31/12/21	1
A1154	31/12/21	1
A1155	31/12/18	0
A1156	31/12/18	0
A1157	31/12/18	0
A1158	31/12/18	0
A1159	31/12/18	0
A1160	31/12/18	0
A1161	31/12/18	0
A1162	31/12/18	0
A1163	31/12/18	0
A1164	31/12/18	0
A1165	15/03/21	0
A1166	31/12/19	0
A1167	31/12/19	0
A1168	31/12/19	0
A1169	18/04/22	1
A1170	21/06/20	0
A1171	03/06/21	1
A1172	03/06/21	1
A1173	03/06/21	1
A1174	03/06/21	1
A1175	01/04/21	1
A1176	31/12/21	1
A1177	01/04/21	1
A1178	01/04/21	1
A1179	01/04/21	1
A1180	31/12/21	1
A1181	12/11/18	0
A1182	31/12/21	1
A1183	01/04/21	1
A1184	31/12/18	0
A1185	31/12/21	1
A1186	31/12/21	1
A1187	31/12/21	1
A1188	31/12/18	0
A1189	31/12/18	0
A1190	01/04/21	1
A1191	30/03/21	0
A1192	30/03/21	0
A1193	29/03/21	0
A1194	30/03/21	0
A1195	07/10/18	0
A1196	07/10/18	0
A1197	31/12/21	1
A1198	12/12/18	0
A1199	12/12/18	0
A1200	31/12/21	1
A1201	31/12/21	1
A1202	22/09/19	0
A1203	31/12/21	1
A1204	31/12/21	1
A1205	31/12/21	1
A1206	15/10/21	1
A1207	24/10/22	1
A1208	05/07/20	0
A1209	30/08/20	0
A1210	13/07/20	0
A1211	12/08/21	1
A1212	12/08/21	1
A1213	05/11/20	0
A1214	31/12/21	1
A1215	31/12/21	1
A1216	13/10/20	0
A1217	01/07/22	1
A1218	01/07/22	1
A1219	25/10/22	1
A1220	25/10/22	1
A1221	25/10/22	1
A1222	25/10/22	1
A1223	25/10/22	1
A1224	25/10/22	1
A1225	03/04/23	0
A1226	31/12/21	1
A1235	31/12/21	1
A1236	31/12/21	1
A1237	17/07/22	1
A1238	31/12/21	1
A1239	31/12/21	1
A1240	04/01/22	1
A1241	31/12/21	1
A1242	31/12/21	1
A1243	30/09/22	1
A1244	12/07/22	1
A1245	31/12/21	1
A1246	31/12/21	1
A1247	01/07/22	1
A1248	31/12/21	1
A1249	31/12/21	1
A1250	12/07/22	1
A1251	18/04/22	1
A1252	31/12/21	1
A1253	01/07/22	1
A1254	04/01/22	1
A1262	31/12/21	1
A1263	31/12/21	1
A1282	31/12/21	1
A1283	31/12/21	1
A1284	31/12/21	1
A1285	31/12/18	0
A1286	03/04/23	0
A1287	07/09/22	1
A1288	31/12/21	1
A1289	30/11/22	1
A1290	31/12/21	1
A1291	19/02/23	1
A1292	04/01/22	1
A1293	23/11/22	1
A1294	28/03/23	1
A1295	25/11/21	1
A1296	31/12/21	1
A1297	12/07/22	1
A1309	12/07/22	1
A1310	25/12/22	1
A1311	31/12/21	1
A1353	30/10/22	1
A1354	05/12/22	1
A1355	03/01/23	1
A1356	25/12/22	1
A1357	03/01/23	1
A1358	03/01/23	1
A1359	03/01/23	1
A1360	16/04/23	0
A1361	31/12/21	1
A1362	16/04/23	0
A1363	03/01/23	1
A1364	09/01/23	1
A1365	03/04/23	0
A1366	31/12/20	0
A1367	09/03/23	1
A1368	28/03/23	1
A1369	16/04/23	0
A1370	09/04/23	0
A1371	11/01/23	1
A1372	03/04/23	0
A1373	31/12/18	0
A1374	28/03/23	1
A1375	13/02/23	1
A1376	26/02/23	1
A1377	13/04/23	0
A1378	03/04/23	0
A1379	13/04/23	0
A1380	26/12/22	1
A1381	09/04/23	0
A1382	09/11/22	1
A1383	13/04/23	0
A1384	19/03/23	1
A1385	19/03/23	1
A1386	13/04/23	0
A1387	31/12/21	1
A1388	31/12/21	1
A1389	02/03/23	1
A1411	03/04/23	0
A1412	03/04/23	0
A1413	03/04/23	0
A1414	03/04/23	0
A1415	03/04/23	0
A2244	29/03/22	1

[DOLEARY85 · Accepted solution]

Hi,

add a calculated column with:

Column = IF(DATEDIFF('Table'[Last Trans.],TODAY(),MONTH)>24,1,0)

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍