DAX Fridays #221: INDEX function

preview_player
Показать описание
A refresher of the difference between INDEX, WINDOW and OFFSET and a deeper dive into INDEX function.
Offset functions:

Window functions:

25 days of DAX Fridays challenge:

Join this channel membership to get access to all the recorded bites as they become available:

SUBSCRIBE to learn more about Power and Excel BI!

Our PLAYLISTS:

☼☼☼☼☼☼☼☼☼☼

POWER BI COURSES:

Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:

☼☼☼☼☼☼☼☼☼☼

ABOUT CURBAL:

QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Twitter ► @curbalen

#CURBAL #SUBSCRIBE
  1. Curbal
  2. Power bi
  3. powerbi
  4. Curbal
  5. power bi desktop
  6. power bi tutorial
Рекомендации по теме
DAX Fridays #221: 0:06:38

DAX Fridays #221: INDEX function

Power BI DAX 0:17:04

Power BI DAX Tip : Demystifying INDEX Function

New Dax Functions 0:09:04

New Dax Functions in PowerBI | Index, Offset & Window | MiTutorials

Time to look 0:08:01

Time to look at the new INDEX function in DAX and Power BI

INDEX Function in 0:13:14

INDEX Function in Dax Power BI

DAX | POWER 0:07:59

DAX | POWER BI | FILTER | INDEX Function

Power BI Quick 0:17:01

Power BI Quick Look at Dax Function Offset, Window, Index- AT 123

Power BI- How 1:11:57

Power BI- How to use DAX Functions Offset, Window, Index

Let's explore INDEX 0:15:22

Let's explore INDEX function in Power BI and learn how it is different from other WINDOW func...

DAX Fridays #220: 0:02:34

DAX Fridays #220: SELECTEDMEASURE function

DAX Fridays #219: 0:11:36

DAX Fridays #219: OFFSET function

DAX Fridays #218: 0:07:38

DAX Fridays #218: Window functions in DAX explained with example

PowerBI DAX Tip 0:14:37

PowerBI DAX Tip : Demystifying WINDOW Function

DAX Fridays #189: 0:07:04

DAX Fridays #189: Which function is faster to count rows: COUNT OR COUNTROWS?

#powerbi #dax #index 0:13:42

#powerbi #dax #index #offset #window #orderby #powerbi #dax (Video-12)

How to handle 0:05:01

How to handle BLANK values with the new OFFSET DAX function in Power BI - WINDOW DAX function series

Creating an index 0:03:09

Creating an index column for Power BI

Become a Pro 0:17:13

Become a Pro at OFFSET, INDEX, and WINDOW Functions in DAX | Hindi Tutorial

Creating index numbers 0:08:16

Creating index numbers using DAX in power bi

PRACTICAL WAYS to 0:15:51

PRACTICAL WAYS to use the WINDOW function in Power BI // Beginners Guide to Power BI

38) Realtime use 0:07:16

38) Realtime use of #earlier #values #countrows function in #dax #powerbi @intelligenceforbusiness

Power BI April 0:08:09

Power BI April 2023 update to ORDERBY

Power BI Beginners 0:07:18

Power BI Beginners 199: Power Query Table.AddIndexColumn

#10 - Index 0:06:51

#10 - Index Column in Power BI( in Hindi) | Creating a Index column in Power BI

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

Ruth, please do a productx video part 2. Lets say inflation rates from different countries in the same column. How would proceed to multiply them with productx? And different starting points. That would be a real challenge:-). Anyway I love your videos and the way you teach. The queso cabrales ad😂 made me laugh.

macshock
Автор

Really like how you've used the 25 days of dax example. Thankyou, very useful.

sue_bayes
Автор

Hello Ruth, nice work : how we can define a Row number in my table visual and note that used fields are not in the same table model . Example : my table visual called sales analysis showing 45000 rows, contains 3 fields customer(customerName) / DimDate(Date) / fact(SalesAmount), i need to add a row number that shows all the row id from 1 to 45000

ahmedmj
Автор

I'm speaking for the 118k subscribers here... Please bring back DAX Fridays.. If there's ~300 total DAX measures and you have 235 videos, that leaves 60ish functions left lol.. Just Kidding.. I'm a paid subscriber btw :)

bradj
Автор

The measure 'Day 2' may not work as expected in case there is a tie. The blank value may be returned. To avoid the issue I’d rather use MINX/MAXX instead of SELECTEDVALUE.

SergiyVakshul
Автор

Thank a lot. But each time I try INDEX functions, it gives "INDEX's relation parameter may have duplicate rows.This is not allowed" error.

What could be the reason of that error ? I checked but there is no duplicated rows in my table.

kvanctavukcu
Автор

Sorry it's a bit unrelated but I heard that we can edit the data model, create relationships, modify DAX in Power BI service.
I believe there's a related video coming up soon?
I'm so hoping we can also "Get Data" from there which would save me tons of trouble having to login RDP, remote servers....

kahhengyeong