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

Aimeeclaird — Thu, 24 Sep 2020 13:46:19 GMT

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

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

dedelman_clng — Thu, 24 Sep 2020 16:29:18 GMT

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

topic Measure to Count blanks of a date in the model is at least + 1 week/7 days in DAX Commands and Tips

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

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