Forum Discussion
Need Measure to show behavior AFTER date from column
- 2 years ago
I applied exactly the same measures - please check.
If it not marked at closed, it would be assumed to be open.
Your sample data is inconclusive. None of the business that received the 6 month letter have been inspected after that.
- 3Jk33f32 years ago
Helper I
It was a lot of data with sensitive information, I tried my best to turn it into sample data. Thank you for attempting. I will take a look at the PBIX and your formulas and see if I can apply to the actual data sets. Thank you again, I really appreciate your time and effort.
- 3Jk33f32 years ago
Helper I
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?
- lbendlin2 years ago
Super User
not really. See if you can produce sample data that would cover all possible scenarios.
- 3Jk33f32 years ago
Helper I
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
- lbendlin2 years ago
Super User
I applied exactly the same measures - please check.