Define the values based on date

[Anonymous]

Please help me to define Cust IDs based on Sales Date range. Please find the source data.

EX:

<= 1 Year = Active

>2 Year = Less Active

>3 Year  = Attention

[Anil_Babu_Samineni]

May be Buckets or Nested IF Statements

[sunny_talwar · Accepted solution]

May be this

Table:

LOAD [Cust ID],

    [Sales ITM],

    [sales date],

    If([sales date] >= AddYears(Today(), -1), 'Active',

    If([sales date] >= AddYears(Today(), -2), 'Less Active', 'Attention')) as Flag

FROM

[..\..\Downloads\Inventry.xlsx]

(ooxml, embedded labels, table is Sheet1);

[tresesco]

Try like:

if(age(Today(),  [sales date])<=1, 'Active',(if(age(Today(),  [sales date])<=2, 'Less Active', 'Need Attention'))) as Flag