Products not sold within certain period

[gbarr12345]

Hi everyone,

I'm looking to create a measure that shows the products not sold for a certain period without needing slicers for the period.

I have attached a PBIX that has a measure that seems to work but I have no date or period filters within and not sure how to integrate it correctly.

Any help would be greatly appreciated!

PBIX - https://drive.google.com/file/d/1hGLHOQ8fBKMsMAvRHoNeip4qPEGokiFg/view?usp=drive_link

Not Sold = IF(ISBLANK([total_sales]), "Yes", BLANK())

[jmerencilla]

Hello! How do I modify this DAX? I have a similar problem where in I need to categorize a product if it has not been sold to a customer in the last 2 years. "New" will be no sales in the last 24 months, "Existing" if the product has been sold to the same customer within 24 months. Thank you!

[amitchandak · Accepted solution]

@gbarr12345 , Simply sum it using Product dim or column

Not Sold = Sumx(Values(Product[Product]), IF(ISBLANK([total_sales]),1, BLANK()) )

[gbarr12345]

Hi Amit,

This worked! Thank you so much!