Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
after so many hours i'm still not able to manage something.
I have a matrix Table like this
I have first a category of items
With dimension (DIM)
Without Dimension (UNI)
I would like to have Quantity = 4 in Warehouse 013 Since i have one size on each item reference
I have created a Summarized table which shows me exactly what i'm looking for.
However, i Absolutely don't no i'n my model how to join that table. since I do not have any unique Key
Does anybody have any advice?
Maybe i could use a measure?
Many thanks for your help!
Solved! Go to Solution.
Hi, @PowerUserR
Yep, i have to use that data
I Think i found a non conventional solution which consist in creating a new column with
[ITEM CODE]&[WarahouseID] in my stock table.
Then Summarize data with addcolumn(summarize(....
and link that virtual table to stock table.
Hi, have you tried connecting the desired table to the table above it? From a first glance it looks like they have a column in common.
I assume that you've tried this already?
If this doesn't help, I think having some sample data or the pbix file could help.
Hi, @PowerUserR
Yep, i have to use that data
I Think i found a non conventional solution which consist in creating a new column with
[ITEM CODE]&[WarahouseID] in my stock table.
Then Summarize data with addcolumn(summarize(....
and link that virtual table to stock table.