DATE RANGES - AMOUNT SOLD DURING TIME FRAME

Question

Dear all,&nbsp;In this case i want to visualize the amount of items sold during a a certain time frame.&nbsp;I want to import a table with diferent date ranges, f.e:&nbsp;Item ID&nbsp; &nbsp; &nbsp; &nbsp; ITEMS SOLD&nbsp; &nbsp; &nbsp; START DATE&nbsp; &nbsp; &nbsp;END DATE123&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHAT I WANT&nbsp; &nbsp; 01/02/2020&nbsp; &nbsp; &nbsp;20/02/202012345&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; WHAT I WANT&nbsp; &nbsp; 01/02/2020&nbsp; &nbsp; &nbsp;22/02/2020&nbsp;Thing is, i dont have any idea what DAX to use, im pretty new with the interface. Also, i have imported the data from an excel table that ive been updating but it is not reliable, are there any ways to set time frames on my dashboard table without updating the excel table?&nbsp;Thanks!&nbsp;&nbsp;

greg_deckler · Answer

So what does your source data look like?&nbsp;Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
&nbsp;

garmas97 · Answer

Hi,&nbsp;It is the same as shown, the list of items id's with their start date and end date.&nbsp;&nbsp;

coreyp · Answer

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.

garmas97 · Answer

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.&nbsp;

coreyp · Answer

Can you please provide a sample set of data? Thanks!&nbsp;

Forum Discussion

DATE RANGES - AMOUNT SOLD DURING TIME FRAME

5 Replies

Related content

People active during Date Range

Error during refresh

Error during refresh

Error during update

Power Query Add rows of zero amount