Forum Discussion

JoshK's avatar
JoshK
Frequent Visitor
7 years ago
Solved

How to exclude last 4 days from a count

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

Need Help
Tutorial Requests
  • Stachu's avatar
    Stachu
    7 years ago

    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)



2 Replies

  • Stachu's avatar
    Stachu
    Icon for Community Champion rankCommunity Champion
    7 years ago

    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)