Power BI DAX Hack: Previous Value Without Date Field (Advanced Technique)

In this Power BI DAX tutorial, you'll learn how to show the previous value by date in a visual without actually using the date field in the visual. This technique can be useful in cases where you want to compare values from different dates without cluttering the visual with dates. You'll see how to use the CALCULATE, FILTER, EARLIER, and RANKX functions to create a measure that calculates the previous value based on the order of the dates. By the end of the video, you'll have a better understanding of how to leverage DAX to manipulate and present data in Power BI. 👍 If you enjoy this video and are interested in formal training on Microsoft Teams, Power BI, Power Apps, Azure, or other Microsoft products you can visit https://prag.works/NICK40 for 40% off On-Demand Learning! -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - - Next step on your journey: 👉 On-Demand Learning - Start With The FREE Community Plan: https://prag.works/odl-trial-yt 🔗Pragmatic Works On-Demand Learning Packages: https://pragmaticworks.com/pricing/ 🔗Pragmatic Works Boot Camps: https://pragmaticworks.com/boot-camps/ 🔗Pragmatic Works Hackathons: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Virtual Mentoring: https://pragmaticworks.com/virtual-me... 🔗Pragmatic Works Enterprise Private Training: https://pragmaticworks.com/private-tr... 🔗Pragmatic Works Blog: http://blog.pragmaticworks.com/ Let's connect: ✔️Twitter: https://prag.works/yt-twitter ✔️Facebook: https://prag.works/yt-fb ✔️Instagram: https://prag.works/yt-insta ✔️LinkedIn: https://prag.works/yt-li ✔️Discord: https://prag.works/yt-discord Pragmatic Works 7175 Hwy 17, Suite 2 Fleming Island, FL 32003 Phone: (904) 638-5743 Email: training@pragmaticworks.com #pragmaticworks #fyp 00:00 Intro 02:29 Creating a Measure for Latest Sale Price 04:33 Creating a Virtual Table for Ranking Previous Dates 06:43 Applying Filters to Identify Previous Sale Prices 08:57 Deleting the Test Rank Column and Ensuring Proper Functionality 10:11 Extending the Solution to Calculate Second, Third, and Last Three Sale Prices