Dates that are over 35 days old

[JENS]

Hi i need to find data (outdtanding debts) that are over 35 days , im using Table (custtransopen)  field : Duedate

What is the correct querry setup?

this works but, there must a more correct way :

ADDCOLUMNS( SUMMARIZE( CALCULATETABLE('CUSTTRANSOPEN' ; DATESBETWEEN('CUSTTRANSOPEN'[Date];today()-999;today()-35) ); 'CUSTTRANSOPEN'[Date]);"Period";"Over 35 Days") ;

[Greg_Deckler]

Something like this might work:

Table = CALCULATETABLE(Data,Data[Date]>TODAY() - 35 * 1.)

[JENS]

that dident work: 😞
over35 = CALCULATETABLE(CUSTTRANSOPEN;CUSTTRANSOPEN[Date]>TODAY() -35 * 1,0)

[v-shex-msft]

Hi @JENS,

>>over35 = CALCULATETABLE(CUSTTRANSOPEN;CUSTTRANSOPEN[Date]>TODAY() -35 * 1,0)

The formula seem filter the records which date diff are smaller than 35 days, I modified the formula, you can try to use below formula

Table = CALCULATETABLE(Table,Table[Date]<TODAY()-35)

Regards,

Xiaoxin sheng