Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
there are two tables visit, stock count. the scnario is we need the stock count quantity in visit table by comparing the customer and date. there might be more tahn 1 visit for a customer in a day.
customer->visit(one-many)
customer->stock count(one-many)
Thanks
Solved! Go to Solution.
@Anonymous
You may try to use SUMX and RELATEDTABLE.
@Anonymous
You may try to use SUMX and RELATEDTABLE.