Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |