I need a measure wich returns me the first purchase of customers who bought product B (key product 2)
This is my data model
Go to Solution.
Create a measure using DAX as below:
VAR KeyDate = CALCULATE(MIN('Calendar'[KeyDate]), FILTER('Calendar', 'Calendar'[Date] = MIN('Calendar'[Date])))
VAR KeyProduct = CALCULATE(MIN('Product'[KeyProduct]), FILTER('Product', 'Product'[Product] = "B"))
CALCULATE(MIN('Customer'[Name]), FILTER('FactSales', 'FactSales'[KeyDate] = KeyDate && FactSales[KeyProduct] = KeyProduct))
View solution in original post
@v-yuta-msft, Maybe I expressed myself wrong.
I meant I need to now every date of first purchase by customer
Customer A - 20/01/2018
Customer B - 14/01/2018
Customer C- 22/01/2018
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.