How to exclude last 4 days from a count

[JoshK]

Hi,

I am currently trying to setup a report which shows a simple count of a book of business.

This count will be based on 'business inception date' (which I have as a field in PBI) and 'live policies' (also have as a field in PBI) but I need to exclude from this count anything that has been incepted within the last 4 days when the report is run.

e.g.

IF 'Inception date' is within last 4 days from NOW then exclude.

Thanks,

Josh

[Stachu · Accepted solution]

something like this should work, you just have to adjust the blue code to match your model

Count Excluding last 4 = CALCULATE([Regular Count], Table[business inception date]< TODAY()-4)

[JoshK]

Thank you! Worked perfectly