Microsoft Power BI Cookbook

Prior time period measures

1. Create Prior Year (PY), Prior Year to Date (PYTD), and Prior Month to Date (PMTD) measures:

Internet Sales (PY) = CALCULATE([Internet Sales],FILTER(ALL('Date'), 'Date'[Date] >= MIN('Date'[Prior Calendar Year Date]) && 'Date'[Date] <= MAX('Date'[Prior Calendar Year Date])))Internet Sales (PYTD) = CALCULATE([Internet Sales], FILTER(ALL('Date'),'Date'[Calendar Year] = MAX('Date'[Calendar Year])-1 && 'Date'[Date] <= MAX('Date'[Prior Calendar Year Date])))Internet Sales (PMTD) = CALCULATE([Internet Sales],FILTER(ALL('Date'),'Date'[Calendar Year Month Number] = MAX('Date'[Calendar Year Month Number])-1 && 'Date'[Date] <= MAX('Date'[Prior Calendar Month Date])))

• Applying both the MIN() and MAX() filter conditions against ...