Find Material from a Lastdate - 6 month from today

[DrillDownBI]

Hi,

I have a Last Good Received date on every material, now I want to find only thoose Material that have Last Good Received Date older than 6 month from today.

[amitchandak · Accepted solution]

@DrillDownBI ,

use this measure with material in a table visual

measure  =

countrows(filter(Table, Table[Good receive date] < today() -180 ))

or

measure =var _date = date(year(today()), Month(Today())-6, day(Today()))
return
countrows(filter(Table, Table[Good receive date] < _date))

[DrillDownBI]

Hi @amitchandak This point me into the right direction and will be accepted as solution, many thanks.