1st time a Product was Sold in Area

[Anonymous]

Hi there,

So what i am looking to do is based on every sale we have, i want to be able to see when was the 1st time each product was sold in an Area. So for example if store 1 had the below data

Date	Product	Area	Sold
10/10/10	1	1	No
12/10/10	1	1	Yes
17/10/10	1	1	Yes

I would want to be able to display in a table by date a count of 1 for the 12/10/10, because that was the 1st time that product was sold in that area.

Any help would be great

[rohit_singh · Accepted solution]

Hi @Anonymous ,

Please try creating a measure like this :

Min Date =

var _mindate =

CALCULATE(

MIN('Product'[Date]),

FILTER(

ALLEXCEPT('Product', 'Product'[Area], 'Product'[Product]),

'Product'[Sold] = "Yes")

)

RETURN

if(_mindate = max('Product'[Date]) , 1 , 0)

Kind regards,

Rohit

Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂