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.
I have a table of open orders with entry date, quantity, order number, etc. This is connected to a customer table and an item table.
I have a single select slicer for entry date. This filters the report for the Top 15 Items with measures for the Qty Sold on the Selected Date, and the sum of the Qty Ordered before the selected date. I have another table on the report grouped by customer with the same measures.
HEre are the measures:
Hi @astano05 ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
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.
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 |
---|---|
106 | |
105 | |
88 | |
75 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |