Power BI Quick Measures should include a template to calculate “Month-to-Date (MTD) vs Same Period Last Year (SPLY)”. This is a very common reporting requirement. Businesses often want to compare current MTD (for example, July 1–8, 2025) against the same date range from last year (July 1–8, 2024). However, the current Quick Measure options only support full-period comparisons, like full July vs full July last year. This becomes a problem for mid-month reports. Using -SAMEPERIODLASTYEAR only works correctly if the user manually filters the exact same date range, which is not practical for many non-technical users. Currently, the only way to achieve this is through custom DAX, which many business users are not familiar with. Adding a built-in Quick Measure for “Month-to-Date vs Same Period Last Year” would make it easier for users to build accurate, mid-month YoY comparisons without needing to write code. This feature would help thousands of users who build retail, sales, and operations dashboards using MTD metrics. It aligns with existing Quick Measures like MTD, YTD, and Year-over-Year change. Please consider adding this option in the next Power BI update.
... View more