How to Create Multi-Row Formulas in Tableau Prep (Difference From)

📣 Did you find this helpful? Check out our upcoming Tableau Prep Foundations class to learn more skills like this: https://www.eventbrite.com/o/onenumber-15678294163 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. Connect with us: •Book an Office Hour with Eric: https://www.eventbrite.com/e/tableau-office-hours-with-eric-parker-tickets-42691995909 •Tableau Passport Program: https://onenumber.biz/tableau-training-passport •Upcoming Tableau Classes: https://www.eventbrite.com/o/onenumber-15678294163 •Subscribe to the OneNumber Newsletter: https://onenumber.biz/newsletter •Follow Eric on LinkedIn: https://www.linkedin.com/in/eric-parker-37513249/ Resources: •Example Superstore Data (Sign in to Data.World to download): https://data.world/ericparker/sample-superstore-tableau-practice-data •Aggregate Step in Tableau Prep: https://www.youtube.com/watch?v=SUC2DQ1N3uM&ab_channel=OneNumber-TableauExperts