Measure to Count blanks of a date in the model is at least + 1 week/7 days

[Aimeeclaird]

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?!

[dedelman_clng]

Hi @Aimeeclaird  try something along the lines of

MissingDataCount =
VAR __CountDt =
    TODAY () - 5
RETURN
    COUNTROWS (
        FILTER (
            Table,
            Table[Handover Date] < __CountDt
                && Table[Sales Value] = BLANK ()
        )
    )

Hope this helps

David