Forum Discussion

Yonatan1984's avatar
Yonatan1984
Icon for Helper I rankHelper I
4 years ago

Lookup doesn't show data in some rows

Hello everyone. I've a model that shows the tailor made products that I need to manufacture for the costumer. For this I've 2 tables, WORK_ORDR_TRNS (aka WOT) and LGSTC_TRNS_TIME (aka LTT). The fi...
ValtteriN's avatar
ValtteriN
Icon for Community Champion rankCommunity Champion
4 years ago

Hi,

One useful test that I do in situations like this is to apply "clean" and "trim" steps in powerquery. It is possible there is a space or somethin like that messing with the lookup. Another thing to look out for would be the date format. Date columns data tyoes are typically the most vunerable.

Yonatan1984's avatar
Yonatan1984
Icon for Helper I rankHelper I
4 years ago

Hi ValtteriN 

The clean and trim dose'nt work.

Also the date format is equel in all table.