Total Orders Amount Prior Period via DAX in MS POWER BI (Explicit Measure) TotalOrders Prior Period = CALCULATE([Total Orders $],DATEADD(Dates[Date],-1,YEAR)) DATEADD DAX - Returns a table that contains a column of dates, shifted either forward or backward in time by the specified number of intervals from the dates in the current context. The interval by which to shift the dates. The value for interval can be one of the following: year, quarter, month, day | Excel Basement