Скачать или смотреть SPLY% and Same Previous Last Year Sales in Dax Function

🚀 Power BI Tips: Analyzing Year-over-Year Sales Performance with DAX 📊



Are you looking to add meaningful insights to your sales dashboards? Comparing your current sales with the same period last year (SPLY) is a great way to track growth and performance trends. Here's a quick example using



DAX:



✨ Same Period Last Year Sales

Same Period Last Year Sales = CALCULATE([Total Sales], SAMEPERIODLASTYEAR(apple_sample_Sales_Data[Date].[Date]))



✨ SPLY % Change

SPLY % = DIVIDE([Total Sales] - [Same Period Last Year Sales], [Same Period Last Year Sales], 0) * 100



By using these measures, you can effortlessly calculate year-over-year growth and display it in a clear and dynamic way in your reports! 📈



💡 Pro Tip: Use this alongside visualizations like line charts or KPIs to help stakeholders easily understand performance trends.

What are your favorite DAX tricks to analyze sales data? Share in the comments below! 👇



#PowerBI #DAX #SalesAnalytics #DataVisualization #BusinessIntelligence