Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Yonatan1984
Helper I
Helper I

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 fields in the table WOT that contain the order number calls:

1. CUST_ORDR_NBR (format as WHOLE NUMBER - GENERAL)

2. CUST_ORDR_LINE_NBR (format as WHOLE NUMBER - GENERAL)

The fields in the table LTT that contain the order number calls:

1. DOC_NBR (format as WHOLE NUMBER - GENERAL)

2. LINE_NBR (format as WHOLE NUMBER - GENERAL)

The field that I want to show in the Table WOT call CRE_DATIME from LTT.

The formula that I used is LOOKUPVALUE but there is a problem in some rows that the data showes in WOT as blank despite there's a data in LTT for the order an line.

There's a screenshot from WOT in row without data:

Yonatan1984_0-1642505184054.png

There's a screenshot from LTT in the same order:

Yonatan1984_1-1642505317149.png

 

There's a screenshot from WOT in row with data:

Yonatan1984_2-1642505436947.png

This is the formula:

TIME_ORDER = LOOKUPVALUE(LGSTC_TRNS_TIME[CRE_DATIME],LGSTC_TRNS_TIME[DOC_NBR],[CUST_ORDR_NBR],LGSTC_TRNS_TIME[LINE_NBR],[CUST_ORDR_LINE_NBR])

 

7 REPLIES 7
HotChilli
Super User
Super User

"I share all the the sample." - we don't want to see a picture.  We can help you if you post the actual data.

Please share a small pbix which illustrates the problem

I found the solution!

There was a table that I didn't needed, when I delete it from the model, all the data shows.

Probebly the reletionship was'nt right.

v-yanjiang-msft
Community Support
Community Support

Hi @Yonatan1984 ,

By my test, haven't reproduced your problem, could you please share the error sample? It helps resolve issue faster.

Best Regards,
Community Support Team _ kalyj

Hi @v-yanjiang-msft 

I share all the the sample.

I don't get any error, only blank data.

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Hi @ValtteriN 

The clean and trim dose'nt work.

Also the date format is equel in all table.

HotChilli
Super User
Super User

I suggest fully-qualifying the table names in the formula to start with i.e. put the table names in where thay are missing.

If that doesn't work, take a specific example and hardcode the values in the formula to test whether they can be found

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors