Autoplay Next video from Max length

Comparing SalesYTD across Multiple Years (Question by David Briggs)

3,007 views · Published 8 September 2017 · 2:30 · Indexed 14 October 2026

Channel: Avi Singh - PowerBIPro · 2017 · Science & Technology

In this episode, I answer a quick question by David Briggs regarding comparing SalesYTD across Multiple Years.

(I recorded this one on the road - in Minneapolis visiting my sister - so there's some background noise)
Original Question: "Good Evening.  Is there a DAX statement that would allow the graphing of YTD sales for the past several years -- specifically, I have monthly sales for the last several years.  The most current month is July 2017.  I want to compare the yearly sales from January thru July for all previous years.  I can force it with a page filter, but it would be nicer if I could do it dynamically with DAX.  I've seen DAX to calculate the previous year --- but I'm looking for all previous years.  Thanks" - David Briggs

=======================
FREE Power BI Step-by-Step Tutorial http://www.learnpowerbi.com/bonus
👉 Download Lesson PBIX Files at http://www.learnpowerbi.com/bonus-download
✅ Subscribe to always get my latest videos: https://goo.gl/P79Hcr
👪 Join our Facebook Group https://www.facebook.com/groups/talkpowerbi
===Most Popular Playlists===
• Power BI Beginner Tutorial: https://goo.gl/KRRkPG
• Ultimate Calendar: https://goo.gl/pyki4K
• Power BI Data Modeling and more: https://goo.gl/WNtJFv

⚡Power On!⚡
-Avi Singh
http://www.LearnPowerBI.com
http://www.AviSing.com

Comparing SalesYTD across Multiple Years (Question by David Briggs)

More from this channel