Microsoft Power BI Cookbook

Current time period measures

1. Open the Power BI Desktop model locally and create Year-to-Date, Period-to-Date, and Week-to-Date measures:

Internet Sales (YTD) = CALCULATE([Internet Sales], FILTER(ALL('Date'),'Date'[Calendar Year] = MAX('Date'[Calendar Year]) && 'Date'[Date] <= MAX('Date'[Date])))Internet Sales (MTD) = CALCULATE([Internet Sales], FILTER(ALL('Date'),'Date'[Calendar Year Month Number] = MAX('Date'[Calendar Year Month Number]) && 'Date'[Date] <= MAX('Date'[Date])))Internet Sales (WTD) = CALCULATE([Internet Sales], FILTER(ALL('Date'),'Date'[Calendar Year Week Number] = MAX('Date'[Calendar Year Week Number]) && 'Date'[Date] <= MAX('Date'[Date])))

Each measure expression sets an "equal to" condition on the column representing the ...