Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Inputs by customer tracking

I have a database like this to record when a customer sends us an item. DOC_NO       ACCTNO       ENTER_DATE      QTY 123                15423           2017-04-17         1 124                101...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi Anonymous,

     

    You can refer to below steps to calculate with selected day range.

     

    1. Create a table to store the day range.

     

    Selector Range = UNION(ROW("Range",30),ROW("Range",60),ROW("Range",90))

     

     

    2. Add a measure to get the chose item from "Selector Range" table.

    3. Create a slicer with "range" column of "Selector Range" table.

    4. Add a measure to calculate on chosen item.

     

    Calculate Range = 
var currDate=MAX(test[ENTER_DATE])
return
SUMX(FILTER(ALL(test),[ACCTNO]=MAX([ACCTNO])&&[ENTER_DATE]>=DATE(YEAR(currDate),MONTH(currDate),DAY(currDate)-[Selected Item])&&[ENTER_DATE]<=currDate),[QTY])

    5. Drag a table visual to store the result.

     

     

     

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi Anonymous,

 

You can refer to below steps to calculate with selected day range.

 

1. Create a table to store the day range.

 

Selector Range = UNION(ROW("Range",30),ROW("Range",60),ROW("Range",90))

 

 

2. Add a measure to get the chose item from "Selector Range" table.

3. Create a slicer with "range" column of "Selector Range" table.

4. Add a measure to calculate on chosen item.

 

Calculate Range = 
var currDate=MAX(test[ENTER_DATE])
return
SUMX(FILTER(ALL(test),[ACCTNO]=MAX([ACCTNO])&&[ENTER_DATE]>=DATE(YEAR(currDate),MONTH(currDate),DAY(currDate)-[Selected Item])&&[ENTER_DATE]<=currDate),[QTY])

5. Drag a table visual to store the result.

 

 

 

Regards,

Xiaoxin Sheng