Forum Discussion
DATE RANGES - AMOUNT SOLD DURING TIME FRAME
Dear all, In this case i want to visualize the amount of items sold during a a certain time frame. I want to import a table with diferent date ranges, f.e: Item ID ITEMS SOLD ...
To do what you want, your data should have the following fields:
Date Sold
Item Number
Quantity Sold
Then you would use a date slicer on your page, filtering a SUM of quantity sold by item number.
I have all the sales per day per item the thing i want to look the amount of items sold during a time frame, problem is i dont know what DAX to use, right now the table is giving me the total amount of items sold since its existence.
Can you please provide a sample set of data? Thanks!