I have two tables connected together by date. I want to create a calculation which will calculate the earlies and the latest date per customer.
First Contact Column = CALCULATE ( MIN(DimDate[Date]), ALLEXCEPT(FctTrc, FctTrc[Customer]) )
I have create a calculation but it giving me the earliest date of the date table.
Any help?