Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Boolean function to pin date range

Hello   I am struggling to create a formula to crack this (seemingly simple) nut.   I have two tables:   Table A contains user ID's and the date they attended training in sales techniques   T...
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , Create a new column in Table A

     

    Sumx(filter(TableB,TableA[UserID] = TableB[UserID] && TableB[Date] >= TableA[date] -2 && && TableB[Date] <= TableA[date] +2),TableB[number of sales])

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Create a new column in Table A

 

Sumx(filter(TableB,TableA[UserID] = TableB[UserID] && TableB[Date] >= TableA[date] -2 && && TableB[Date] <= TableA[date] +2),TableB[number of sales])