DAX Measure - Get Prior Amount

[Anonymous]

hello all - i have a table that shows customer order information - Order Id, Customer Id, Order Date, Status, Amount. If i select a time period - month, quarter, etc. i need to show the the last period Amount. For example, if i select 2019 March, i want to show the Order Amount where the order date = March 1st 2019. Any ideas?

[Tahreem24]

Hi @Anonymous,

You can calculate the First day of the month using below DAX formula:

FirstdayofMonthSales = CALCULATE(sum(Data[Sales]),STARTOFMONTH(Data[Date]))

Please accept my answer as a solution if Its helped you!!!

[Anonymous]

Hi,

I assume you are wanting to do a Date Filter. There are multiple Types in this, You could use a Drop down Date Filter or a Slicer to Specify the Date Range ( Start and End Date).

1. Single Date Value

Value := 
VAR Date= SELECTEDVALUE(Order[date])
RETURN CALCULATE(SUM(Order[Order], Order[date]= Date)

2. Date Range (Slicer)

Value:= VAR First_Date= FIRSTDATE(Order[date])
VAR Last_Date=LASTDATE(Order[date])
RETURN CALCULATE(SUM(Order[Orders]), FILTER(Order, Order[Date] >= First_Date && Order[Date]<= Last_Date))

Best Regards,
Vignesh M

If what I suggested worked for you feel free to Drop a "Kudos" and Consider to "Accept as Solution" if I solved your Issue 🙂

[Anonymous]

---

@Anonymous wrote:

Hi,

I assume you are wanting to do a Date Filter. There are multiple Types in this, You could use a Drop down Date Filter or a Slicer to Specify the Date Range ( Start and End Date).

1. Single Date Value

Value := 
VAR Date= SELECTEDVALUE(Order[date])
RETURN CALCULATE(SUM(Order[Order], Order[date]= Date)

2. Date Range (Slicer)

Value:= VAR First_Date= FIRSTDATE(Order[date])
VAR Last_Date=LASTDATE(Order[date])
RETURN CALCULATE(SUM(Order[Orders]), FILTER(Order, Order[Date] >= First_Date && Order[Date]<= Last_Date))

---

I just did a test but it is returning the same value as the Amount. See below. For example, for customer 456, date 4/1/2019, the Value measure should be 50. Thoughts?