Forum Discussion

GuidoPinares's avatar
GuidoPinares
Helper I
3 years ago
Solved

Searching a Previous date

Hi community,   This probably is a very easy problem but I am strugling with it, I hope you can help me.   Basically I have two different Tables:   Sales(CustomerID, DateSold) Activities(Custo...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    3 years ago

    GuidoPinares , NEw column

     

    Activities Before= var _cnt = countx(Activies, Sales[Customer ID]=Activies[Customer ID] && Activies[Activity Date] <= Sales[Date Sold]) ,  Activies[Customer ID] )

    return

    if(isblank(_cnt), false(), true ())

     

     

    First Purchase = var _date = minx(filter(Sales, Sales[Customer ID]= earlier(Sales[Customer ID])), Sales[Date Sold])
    return
    if(Sales[Date Sold] =_date, TRUE(), FALSE())

amitchandak's avatar
amitchandak
Super User
3 years ago

GuidoPinares , NEw column

 

Activities Before= var _cnt = countx(Activies, Sales[Customer ID]=Activies[Customer ID] && Activies[Activity Date] <= Sales[Date Sold]) ,  Activies[Customer ID] )

return

if(isblank(_cnt), false(), true ())

 

 

First Purchase = var _date = minx(filter(Sales, Sales[Customer ID]= earlier(Sales[Customer ID])), Sales[Date Sold])
return
if(Sales[Date Sold] =_date, TRUE(), FALSE())