By: Eric Parker
Eric Parker lives in Seattle and has been teaching Tableau and Alteryx since 2014. He's helped thousands of students solve their most pressing problems. If you have a question, feel free to reach out to him directly via email. You can follow him on LinkedIn or sign up for a Tableau Office Hour to work with him directly!
One of the most powerful, underrated features in Tableau Prep is the Difference From or "Multi-Row Formula" function. It allows you to calculate the difference in values between rows of data. This is useful when you need to calculate the time elapsed between dates or the general difference in values (e.g. dollars, counts, temperatures) from one row to the next.
This kind of calculation is only available in Tableau Desktop with a Table Calculation which is limiting because Table Calculations can only execute against data that's present in a worksheet. Pre-calculating differences in the underlying data can be a game-changer!
If you're looking to harness the power of SQL's LOOKUP/PARTITION in Tableau Prep, look no further! Check out this video for a full breakdown.
📣 Did you find this helpful? Check out our upcoming Tableau Prep Foundations class to learn more skills like this.
Need help with Tableau? Sign up for an office hour to work with Eric! You can also check out our upcoming classes for a Tableau deep dive!
Related Resources
Downloadable Data Source (Sign in to DataWorld to download)
Want to keep learning foundational skills in Tableau? Sign up for our weekly newsletter so you never miss new blog posts, videos and events!