return a list of items that have not been sold in 3/6/9 months

[Matej]

Hello, I'm trying to return only a list of items that have not been sold in the last 3/6/9 months. I also have a calendar table created and connected but I'm not very versed in time inteligence in PBI so I'm unsure how to formulate the right measure. 

[MohTawfik · Accepted solution]

Check this one
creating months period parameter as follows

Then creating measure

Not Sold Items = 

Var Last_Sold_Date=
Max('Table'[Last item Fulfillment Date])

Var Period_END_Date=
DATE(
    year(now()),
    month(now())-'Last Months period'[Last Months period Value],
    DAY(now()
    )
)

Var Result =
If (
    Last_Sold_Date > Period_END_Date,
    "Sold",
    "Not Sold"
)

Return 
Result

on matrix visual, you can filter by "not sold"

hope this solves your issue

[Matej]

This is great! Thanks a lot for the help, really appreciate it.