Count number of item is 180 days old

[Anonymous]

Hello All

I am trying to get the number of items which is passed 180 days of a time period. 

I did tired Measure but it did not work

I have 2different kind of document and both need to be count individual. 

CALCULATE(COUNTROWS('Native Documents'), 'Native Documents'[Document Type]="SOP", 'Native Documents'[Document Owner Approval Date]>= 180)

Any help will be appreciated

Thank you

[JIGAR · Accepted solution]

@Anonymous 

If I understood this correctly, you need to show count of documents which are 180 days old. You will have to modify your measure formula. Please see the below formula :

= CALCULATE(COUNT(Native Documents[DocumentID]),FILTER(Native Documents,'Native Documents'[Document Type]="SOP" ),FILTER(Native Documents,DATEDIFF(Native Documents[Document Owner Approval Date],TODAY(),DAY) > 180))

Hope this helps !!

Please mark it as accepted if this was appropriate.

Thanks

[Anonymous]

Hi @JIGAR 

I will try your formula. 

Yes, it has to count the Number of SOP Document is over 180 days. 

Thank you 

[JIGAR]

@Anonymous 

Great.

Mark it as accepted if the solution was appropriate.

Thanks

[calerof]

Hi @Anonymous ,

How about sharing some sample data to try to help you?

Regards,

Fernando