October 28 & 29: Experts share their secrets on how to pass the Fabric Analytics Engineer certification exam—live. Learn more
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 |
Solved! Go to Solution.
Hi,
add a calculated column with:
Hi,
add a calculated column with:
User | Count |
---|---|
105 | |
99 | |
98 | |
86 | |
49 |
User | Count |
---|---|
162 | |
142 | |
132 | |
102 | |
63 |