Forum Discussion
Solved
FIRSTDATE and LASTDATE Functions
Hi Community, I am trying to get only the FIRST order of a customer. A customer can have many orders. The measure created is : CALCULATE(MIN('Date'[DateOrdered]),ALL(Date'[Date])) N...
Thank you community , I searched past post and came across post that helped me solve it.
I wrote another measure as a
Check =var datecheck= MIN('Date'[Date])ReturnIF( [FirstOrder]= datecheck, 1, 0)With this check set as 1, It returns all FIRST DATE of a customer that is same to the slicer Selection date.Cheers.
amitchandak yes all you mentioned it gives all first date order of a customer.
BUT now I want to filter those first date based on slicer date selected.
Slicer chosen is AUg 2020 but first date shows all record of First date for a customer from 2009 also.
Thank you community , I searched past post and came across post that helped me solve it.
I wrote another measure as a
Check =
var datecheck= MIN('Date'[Date])
Return
IF( [FirstOrder]= datecheck, 1, 0)
With this check set as 1, It returns all FIRST DATE of a customer that is same to the slicer Selection date.
Cheers.