Extracting unique list from column in excel returns null value in BI

[ashley95e]

Extracting  unique list from a column in excel returns null value when imported into  in BI - The data was imported from another source had to be converted to Text or would convert to 1904 system ...soooo  excel =TEXT(S2,"mm/d/yyyy" ) keeps date from converting but any further minulipulation of data converts to null in BI

[Greg_Deckler]

Any chance you can post a sample of the data?

[ashley95e]

Sure, just a bunch of dates

unique's for a look up

40671 40629 40404 40084 40056 40014 40735 40664 40482 40452 40416 40321 40293 40139 39989 39972 40678 40650 40496 40468 40454 40388 39477 39306 39257 39005 38990 38581 38557 38541 38491 38480 38247 38234 40712 40657 40622 40258 40111 40046 40038 39978 39968 39940 39861 39846 39825 39812 39768 39740 39688 39664 39646 39629 39599 39432 39418 39401 39384 39299 39271 40475 40437 40359 40307 40075 40049 40021 40005 39956 39915 39870 39838 39782 39724 39670 40118 40083 39988 39636 39615 39550 39516 39475 40399 40385 40364 40330 40287 40264 40238 40214 40180 40161 40112 40094 40068 40027 40685 40284 40076 39985 39970 39958 39788 39774 39734 39714 39695 39683 39658 39561 40736 40700 40658 40640 40342 40216 40174 40132 40080 40031 40013 39976 39944 39881 39797 39761 39741 39660 39633 39403 39391 39356 39317 40714 40677 40635 40580 40514 40493 40420 40386 40363 40332 40204 40177 40720 40711 40693 40362 40340 40250 40209 40157 40081 40067 40043 40017 39997 39962 39859 39829 39747 39693 39656 39623 39595 39572 39548 39529 39515 39466 39426 39395 39369 39345 39319 39291 40675 40608 40574 40551 40530 40500 40474 40431 40335 40300 40257 40237 40208 40485 40410 40367 40313 40097 40091 40062 40048 40034 39860 39845 39823 39789 39765 39719 39698 39672 39649 39621 39591 39507 39460 39382 39278 39216 39187 39158 39108 38998 38963 38935 38890 39762 39712 39692 39361 40684 40643 40577 40733 40740 40370 40244 40220 40698 40683 40649 40595 40566 40479 40440 40742 40726 40286 40251 40230 40202 40181 40594 40524 40483 40620 40349 40314 40279 40129 40088 40721 40508 40412 40361 40328 40265 40194 40165 40123 39909 39886 40406 40245 40090 40064 39999 39959 39927 39663 39612 39328 39279 39203 39186 40713 40687 40616 40590 40391 40357 40252 40187 40167 39990 39969 40602 40581 40724 40704 40665 40656 40528 40519 40472 40461 40451 40427 40719 40670 40494 40455 40402 40339 40311 40291 40242 40218 40193 40152 40137 40122 40007 39955 40728 40692 40642 40615 40525 40527 40510 40426 40706 40460 40585 40560 40504 40343 40315 40210 40153 40066 39916 39901 39885 39843 40717 40654 40486 40425 40395 40290 40188 40045 40481 40432 40418 40381 40356 40285 39979 39905 39879 39807 40707 40414 40613 40509 40444 40690 40679 40621 40549 40495 40392 40168 40133 40042 40024 39996 40421 40369 40348 40256 40215 40178 39836 40539 40466 40405 40384 40312 40146 40734 40703 40172 40147 40127 40676 40304 40283 40232 40207 40098 40697 40623 40614 40333 40260 40225 40197 40158 40138 40109 40054 40159 40699 40663 40587 40552 40521 40501 40691 40558 40480 40453 40655 40599 40572 40544 40705 40612 40567 40543 40459 40397 40731 40669 40564 40503 40497 40662 40627 40588 40609 40417 40438 40489 40473 40446 40376 40341 40273 40259 40231 40196 40154 40377 40318 40686 40538 40517 40382 40353 40301 40271 40648 40600 40488 40409 40682 40741 40526 40502 40462 40195 40644 40511 40448 40393 39964 40350 40322 40110 39992 39965 39950 39930 39746 40718 40441 40398 40190 40012 39727 39679 40434 40396 40433 40186 40151 40119 39877 39851 39818 39773 39754 39705 39677 39606 39397 39377 39368 40400 40355 40126 40099 40661 40557 40516 40668 40727 40688 40201 40028 40009 39980 39949 39928 39874 39833 39804 39711 39657 39642 39404 39334 39320 39300 40725 40023 39937 39661 39335 39289 40647 40507 40336 40306 39971 39936 39887 39852 39796 39720 39635 39607 39531 39488 39458 39448 39346 39298 39269 39248 39222 39201 38984 38968 38942 38906 38886 38875 40747 40672 40411 40101 40070 40053 40026 40000 39982 39894 39856 40490 40319 40096 40029 40006 39908 39824 39780 39748 40125 39991 39957 39732 40447 40299 40710 40217 40055 39731 39689 39619 39600 39508 39452 39411 40739 40578 40553 40537 40476 39671 39630 39608 39588 39338 39307 39268 39250 39223 40531 40628 40334 40298 39864 39822 40636 40545 40387 40351 40116 40069 40051 39684 39659 39650 39627 39355 39329 39270 40389 40371 40327 40248 40234 40213 40192 40041 39685 40439 40253 40182 40136 40120 40086 40004 39983 39786 39760 40729 40634 40559 40515 40419 40160 40150 40144 40104 40074 40047 39914 39878 39842 39816 39787 39586 39566 39517 39489 39468 39446 39424 39405 39287 39251 39230 39152 39129 39107 39081 39040 39012 38971 38947 38921 38900 38865 38844 38654 38627 38592 38578 40522 40430 40571 40403 40272 40175 40131 40008 39775 40593 40487 40470 40346 40269 39943 39913 39873 40573 40542 40323 40227 39921 39828 39651 39622 39315 39292 39264 39253 39110 39097 39037 38794 38774 38739 38656 38634 40630 40518 40366 40223 40173 40078 40019 39942 39730 39716 39701 39597 39579 40601 40478 40456 40368 40246 40103 40063 39809 39772 39744 39598 39419 39376 39286