Solved: Relationship

Anonymous · ‎10-14-2019

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

v-chuncz-msft · ‎10-14-2019

@Anonymous

You may try to use SUMX and RELATEDTABLE.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

v-chuncz-msft · ‎10-14-2019

@Anonymous

You may try to use SUMX and RELATEDTABLE.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.