Forum Discussion

3Jk33f3's avatar
3Jk33f3
Icon for Helper I rankHelper I
2 years ago
Solved

Need Measure to show behavior AFTER date from column

I've searched the forum and haven't come across close to what I need. We have a program internally that insepcts customer activity. There were some customers that received a letter 6 months into the...
Need Help
3Jk33f3's avatar
3Jk33f3
Icon for Helper I rankHelper I
2 years ago

lbendlin I tried your formulas with my actual data set and I achieve the same results as you. The formula is not registering a difference between a business that did receive a 6 month letter and one that did not. It's also not registering all the businesses that did receive a 6 month letter. Could it be that it's because it's a SharePoint date column?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

not really.  See if you can produce sample data that would cover all possible scenarios.

  • 3Jk33f3's avatar
    3Jk33f3
    Icon for Helper I rankHelper I
    2 years ago

    lbendlin Ok, I redid the data sets without modifying them. I just deleted the location information. This is the truest form of the data. 

     

    Reference: Business Reference 

    Input: Input 

  • 3Jk33f3's avatar
    3Jk33f3
    Icon for Helper I rankHelper I
    2 years ago

    lbendlin Yes, Perfect! Thank you so much for your patience and assistance!