Measure to Count blanks of a date in the model is at least + 1 week/7 days
Hi, I want to write a measure that counts the number of blanks in a column when the date in another column is at least 5 days passed. Example, the data is a from a CRM, I am reporting on data quality. I want to give the users 1 week to populate the other column before I flag it as missing data. Handover Date Sales Value 01/08/2020 23/09/2020 20/08/2020 £1000 07/07/2020 £1000 Based on the example of my data, I would only count 1 blank. Any suggestions please, experts?!