Forum Discussion
Helper INeed Measure to show behavior AFTER date from column
I applied exactly the same measures - please check.
Helper ISorry for the confusion. It is possible the inspector made an error when inputting the data. I've had to modify the Powerapp to only take in the number of lid bins that business owns to avoid that error from the inspector.
Super UserNo need to apologize - i just want to understand what rules to apply in such scenarios. Should the non-inspected container count as open or closed?
- 3Jk33f3
If it not marked at closed, it would be assumed to be open.
- lbendlin
Your sample data is inconclusive. None of the business that received the 6 month letter have been inspected after that.
- 3Jk33f3
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.
- 3Jk33f3
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
not really. See if you can produce sample data that would cover all possible scenarios.
- 3Jk33f3
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
- lbendlin
I applied exactly the same measures - please check.