How to use OFFSET DAX function in Power BI / Get Previous Data // Beginners Guide to DAX in Power BI

In this video we cover how you can use the newest DAX function OFFSET to get previous data within your tables.
-
🚩 Get Demo Files here
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solu...
solutionsabroa...
❤ Other ways to support
ko-fi.com/solu...
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of UA-cam.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.micros...
#PowerBI #DataAnalytics #BusinessIntelligence

[@Kay_Parzival]

Your tutorials are easy to understand and very practical...Great Job Fernan!

[@tamasvadoc476]

Really interesting and useful concept, thank you. Been looking for this, only was able to find a function to do this, however, it was for a new column, not a measure.

[@gnavarrolema]

Great demo Fernan!!!

[@SolutionsAbroad]

Thank you for your kind words sir!

[@williamarthur4801]

This has been something where excel was better. thanks for introducing it.

[@yulandit]

it's very useful, fernan.
Can you explain how to calculate the sum from the second row upwards column sales?

[@PURVASAWANT-g1f]

It's very useful

[@markedralin9776]

do you know how to calculate current_row = fix_value * previous_row?