Forum Discussion
Last Transaction Date with Filter?
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] )
)
2 Replies
Anonymous
What if you add ProductName in ALLEXCEPT arguments
Last Transaction = CALCULATE ( LASTDATE ( 'Sales Details'[SalesTxnTimeModified] ), ALLEXCEPT ( 'Customer', 'Customer'[Customer Name], 'TableName'[ProductName] ) )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
