Last Transaction Date with Filter?

[ballist1x]

How can i create a last or first transaction date for a customer by the manufacturer of what they ahve bought?

i cerate a first order or last ordser date calculation using the following, but how can i just create this for say Heinz product? when the customer buys many kinds of products with different transaction dates?

Last Transaction =
CALCULATE (
    LASTDATE ( 'Sales Details'[SalesTxnTimeModified] ),
    ALLEXCEPT ( 'Customer', 'Customer'[Customer Name] )
)

[Zubair_Muhammad]

@ballist1x

What if you add ProductName in ALLEXCEPT arguments

Last Transaction =
CALCULATE (
    LASTDATE ( 'Sales Details'[SalesTxnTimeModified] ),
    ALLEXCEPT ( 'Customer', 'Customer'[Customer Name], 'TableName'[ProductName] )
)

[ballist1x]

@Zubair_Muhammad

thanks Zubair, is there any way to do this using drop down slicers and filters?

this si sample data below, i want to be able to put thew data in the table so that we can see account numbers and the sales figures and use slicer filters to see the customers who bought for example Henz product in the last 3 months

But then to filter by hierarchy Level 3 as there could be multiple Level 3's for each manufacturer.

YEAR_ENDING

PERIOD

POSTING_DATE

NAV_NO_CODE

NAV_NO_DESCRIPTION

Customer Number

Customer

DOCUMENT_NO

QUANTITY

Revenue

CUSTOMER_NAME

MANUFACTURER

Revenue Group

Hierarchy Level 3

2018

1

01/01/2018

NX-11111

Heinz

ACC155

INVOICE123

1

20

Newci

Heinze

CONDIMENTS

TEA

2018

1

01/03/2018

KTCH1

Ketch

ACC155

INVOICE125

1

15

DALE

Heinze

CONDIMENTS

LUNCH

2018

1

01/01/2018

SLDCRM1

SALAD

ACC156

INVOICE126

6

200

BOROM

WORCESTER

CONDIMENTS

LUNCH