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 ...
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)



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)



JoshK's avatar
JoshK
Frequent Visitor
7 years ago

Thank you! Worked perfectly