Скачать или смотреть Calculate Current & Previous Year Total Sales In POWER BI [ Using DAX ]

✅Learn how to calculate Current Year (CY) and Previous Year (PY) Total Sales in Power BI using DAX—step by step! 🚀
Whether you’re building dashboards, tracking year-over-year growth, or creating dynamic reports, this tutorial will show you the exact DAX formulas and best practices you need.

This video is perfect for beginners and intermediate Power BI users who want to master time-intelligence functions #dax like SAMEPERIODLASTYEAR, TOTALYTD, PARALLELPERIOD and more.

🔑 What You’ll Learn
✅ Create DAX measures for Current Year Total Sales
✅ Create DAX measures for Previous Year Total Sales
✅ Compare sales year over year (YoY)
✅ Make reports dynamic & interactive

🔗 Resources & Next Steps:

Download sample data and Pbix File - https://drive.google.com/file/d/1Gm6W...

Check out our DAX & Time Intelligence playlist - https://studio.youtube.com/playlist/P...

✅Calculated Measures Used :-

👉Current Year Sales =
CALCULATE(SUM(Sales_Details[Sales]),
YEAR('Calendar'[Date])=YEAR(TODAY()))

👉Previous Year Total Sales =
CALCULATE(SUM(Sales_Details[Sales]),
YEAR('Calendar'[Date])=YEAR(TODAY())-1)

✅PLAYLIST✅

✅Other Playlist You Can Watch :

*Complete DAX Bootcamp* playlist here:https://studio.youtube.com/playlist/P...

Scenario Based Power Bi Interview Q & A:-
   • Scenario based Power BI Interview Q & A  

Power BI Tips And Tricks:-
   • POWER BI Tips And Trikes  

Introduction To Power Bi:-
   • Power Bi  

SQL Server Tutorial:
   • SQL Server Tutorial  

🔔 Subscribe to my YouTube channel:-
https://www.youtube.com/channel/UCWfz...

Social Media Link
--------------------------------
LinkedIn:-   / deepan-kumar-patel-777591202  
Facebook:- https://www.facebook.com/dipan.patel....
---------------------------------------------------------------------------------------------------------
Thanks for watching...
"Milestone Creator"

#previousyearsales #currentyearsales #sameperiodlastyear #parallellperiod #totalytd #PreviousWeekSales #PowerBI #DAX #CurrentWeekSales #TimeIntelligence #MilestoneCreator #PowerBIBootcamp