Most recent order sales from customers

Question

How to show sales of a recent order and the first order made by customers from the store?

Answer 1

Hi Nithin,

You can use LASTDATE() to fetch the last purchased date of customer order and FIRSTDATE() to fetch the first date for customer purchase.

first sales = CALCULATE(SUM(Orders[Sales]),FIRSTDATE(Orders[Order Date]))

recent sales = CALCULATE(SUM(Orders[Sales]),LASTDATE(Orders[Order Date]))