Forum Discussion
Lookupvalue return blank
Milan , You can use related, relatedtable(with MAxX, sumx etc) for related table to move data across
Lookupvalue or calculated column to move data acorss
example
a new column in Table 2 from table , add join columns with && and ||
maxx(filter(Table1, Table1[Col1]= Table2[Col1]), Table1[Value])
You can also use sumx, concatenatex
refer 4 ways (related, relatedtable, lookupvalue, sumx/minx/maxx with filter) to copy data from one table to another
https://www.youtube.com/watch?v=Wu1mWxR23jU
https://www.youtube.com/watch?v=czNHt7UXIe8
Sorry, i can´t upload pbix file. So i took screenshoots of same data model, but it is working. Asking in Storecards_movements for data from Storecards. I my project is result blank. Where can be the problem?
UPDATE: I copy original big pbix file and delete all tables except this two (Storecards and Storecards_movements). And it is working, result is not blank... Where can be the problem? What can be the cause of not proper working of lookupvalue?