Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello community,
i have issue with LOOKUPVALUE function. I have experience with LOOKUPVALUE, but behaviour of function in my project is freaky. I have column - storecard number in couple tables (storecards, images etc, around 20 tables). All using is working properly except store movements. If i ask LOOKUPVALUE in store movements for another data from different table, result is blank. Table storecard movements has 400k rows, i tried remove duplicates of storecard numbers (it is not make sence - where it was 1:1 and same result, it is blank... Columns, are same format...
From other side is LOOKUPVALUE not working - as expected - asking in storecards table for result in store movements (A table of multiple values was supplied where a single value was expected.)
Does anybody have any idea how to do that?
Thanks for your help and time
Milan
@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?
User | Count |
---|---|
101 | |
90 | |
83 | |
76 | |
71 |
User | Count |
---|---|
113 | |
104 | |
100 | |
73 | |
65 |