Perform a lag and lead operation in DAX with OFFSET window function

preview_player
Показать описание
In this video Mitchell walks through and discusses the OFFSET function in DAX. This single function provides the capability of LAG and LEAD from T-SQL Window functions. This is an in-depth review of the various parameters and how to perform a lag and lead operation in DAX!

Blog mentioned in video:

-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:

Let's connect:


Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
#PragmaticWorks
  1. Pragmatic Works
  2. Lag and Lead in DAX
  3. DAX OFFSET FUNCTION
  4. Window Functions in DAX
  5. Power BI Tutorial
  6. Power BI DAX Tips
Рекомендации по теме
LAG and LEAD 0:02:25

LAG and LEAD Functions (SQL) - Accessing Data in Other Rows

Lead/Lag Window Analytical 0:10:34

Lead/Lag Window Analytical functions in SQL | Advance SQL concepts

Lead and Lag 0:07:27

Lead and Lag functions in SQL Server 2012

Perform a lag 0:12:54

Perform a lag and lead operation in DAX with OFFSET window function

PMBOK® Guide: Project 0:06:43

PMBOK® Guide: Project Schedule Management- Lead and Lag

Lead Lag 0:07:26

Lead Lag

Lead & Lag 0:08:26

Lead & Lag Window Functions in SQL (EXAMPLES INCLUDED)

LEAD and LAG 0:08:03

LEAD and LAG Functions In SQL | Advance SQL Interview Question (Many Examples)

Project 2016 Tutorial 0:02:28

Project 2016 Tutorial Setting Task Lead and Lag Time Microsoft Training

Lead / Lag 0:10:45

Lead / Lag Function in SQL | SQL Tutorial

Lag and Lead 0:01:40

Lag and Lead in MS Project

Lead Measures VS 0:06:46

Lead Measures VS Lag Measures explained with examples! (Agency growth)

LEAD & LAG 0:04:31

LEAD & LAG Easy Explanation: PMP Preparation

Lead/Lag calculations in 0:00:42

Lead/Lag calculations in Power BI without using DAX

Example: Design Lead-Lag 0:28:48

Example: Design Lead-Lag Controller

SQL Tutorial - 0:08:10

SQL Tutorial - Window Functions - Lag and Lead

Lead Time and 0:03:42

Lead Time and Lag Time - Key Concepts in Project Management from the PMBOK

What are Lead 0:11:00

What are Lead Lag Compensators? An Introduction.

034 LAG and 0:04:23

034 LAG and LEAD function Examples

[SQL] Lead & 0:05:45

[SQL] Lead & Lag Window Function

Why should we 0:03:18

Why should we focus on lead measures vs lag measures?

Spark SQL - 0:10:44

Spark SQL - Windowing Functions - Using LEAD or LAG

Lag & Lead 0:18:31

Lag & Lead function in Snowflake

SQL SUM(), LAG(), 0:15:33

SQL SUM(), LAG(), LEAD(), PARTITION BY

Комментарии
Автор

Thanks a lot! Your explanation is the best! Spend several hours trying to find sql window functions alternative in dax, until found this video. It hits perfectly

randomname
Автор

Exactly what I needed right now. Thank you very much!
My use case is a little bit more complicated, but this window function should do the trick, I hope...

VisioNOIR.
Автор

Thank you! Really appriciate good explanation

KiFiPL
Автор

Thank you!! It really the found of the day

etfcvjf
Автор

really thank you, as you said there is not much helpful information outside

VictorFloresChovis
Автор

This is super helpful, much appreciated. How do you make this dynamic such that you can choose the lead/lag value with a slicer and have the lag applied? I tried creating a Measure but I couldn't get the correct values for the life of me

vblaster