Forum Discussion

GARMAS97's avatar
GARMAS97
Regular Visitor
6 years ago

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      ...
Need Help
GARMAS97's avatar
GARMAS97
Regular Visitor
6 years ago

Hi,

 

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

 

 

  • CoreyP's avatar
    CoreyP
    Solution Sage
    6 years ago

    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's avatar
      GARMAS97
      Regular Visitor
      6 years ago

      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.

       

      • CoreyP's avatar
        CoreyP
        Solution Sage
        6 years ago

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