Forum Discussion
Solved
Get reference from one table to display data in another table
Dear all, First of all, thanks a lot to all the posters for all the answers provided to everyone, which helped me go through a lot of things up to now. Unfortunately I have a syntax question in ...
Hi dprousteau ,
Here are the steps you can follow：
1. Create measure.
MinimalStock = SUMX( FILTER(ALL('TableInfosRefs'), 'TableInfosRefs'[idRef]=MAX('TableJournal'[idRef])&&'TableInfosRefs'[Name]=MAX('TableJournal'[Name])), [MinimalStock])QuantityForOrder = [MinimalStock]- SUMX( 'TableJournal',[JournalQuantity])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi dprousteau ,
Here are the steps you can follow：
1. Create measure.
MinimalStock =
SUMX(
FILTER(ALL('TableInfosRefs'), 'TableInfosRefs'[idRef]=MAX('TableJournal'[idRef])&&'TableInfosRefs'[Name]=MAX('TableJournal'[Name])),
[MinimalStock])QuantityForOrder =
[MinimalStock]-
SUMX(
'TableJournal',[JournalQuantity])2. Result:
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thank you SO MUCH Anonymous , it worked perfectly!