DAX Fridays! #165: Create an index based on two or more columns using DAX

DAX Fridays! #: Creaye an index based on multiple columns using DAX

Do you need to create an index based on multiple columns using DAX? Here is a detailed guide on how to do it. At the end of the video I will disclose the solution for the quiz I gave you two weeks ago.

Links you might need:

SUBSCRIBE to learn more about Power and Excel BI!

☼☼☼☼☼☼☼☼☼☼

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:

▼▼▼▼▼▼▼▼▼▼

If you feel that any of the videos, downloads, blog posts that I have created have been useful to you and you want to help me keep on going, here you can do a small donation to support my work and keep the channel running:

▲▲▲▲▲▲▲▲▲▲

Our PLAYLISTS:

************

************

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

#daxfridays #curbal #SUBSCRIBE

[annarozyc]

Thanks to this solution, I was able to aggregate tables from many rows to rows without duplicates and add up the appropriate value. thank you very much for your great work

Great example, Ruth. Thanks for the video!
How it's possible to add a new index column incremental?
Like a primary key for a Table in a database.

[Balgalw]

This one is such a good example. Used it to calculate each next order for clients, still can't understand, how it works.
Pure magic)

[ximenanunezcams]

can we do this in power query (m code)?

[AlvinRyellPrada]

This is exactly what I am looking for! Thank you Ruth for the library of knowledge.

Question though, is there a way this can be done in PowerQuery?

[icedojo]

Many thanks, I could create the calendar table with index column!

[ShabnamKhan-vkfj]

Great example, Ruth. Thanks for the video! I know you have a video on earlier with cumulative total calculation that you have posted below, it would be fantastic if you can create another earlier example video with a different use-case.

[SgtLostSpartan]

This is exactly what I needed. Thanks and greetings form Mexico!

[poojasahasrabhojanee]

Hi Ruth,
You are super super super awesome 🥰Love you a lot ❤️

[VenkateshReddy-cyit]

Hi Can you also make a video to show row number in Table visual which should be dynamic irrespective of changes happening because of slicer selection or by changing sorting using different columns present in Table.

[Pepe]

Muy agradecido amiga por todos tus videos, realmente útiles. Muchas gracias, saludos

[juanignacioXI]

Great Video and Dax Functions!!! Ty Ruth

[winzero]

Hey ruth. Can i use something like this but in measures instead of calculated columns. I have a dataset of around 3 MM rows, and adding another column would add like 10mb in the pbix file.. Thank you!!

[alonsocarballo]

Great example when you know the colums and rows to filter, but do you know how to create an Index based on a matrix where you can add rows and columns dinamically? not knowing which columns and rows are going to be? and you can add 1 or more fields to the rows, where you can collapse them and still having the index per row?
I have been dealing with this issue for 2 weeks and still having get to a solution.

[sectyhw]

thank you very much, you helped me as usual :)

[shoppersdrugmartcanuck]

Hello!! I'm wondering if I can do this to fix my problem... my "supplier" column is a date column - is it possible for me to create an index where if the other variable of location is just verifying that there's a date in the cell?

[hamzashafiq]

What if I need to group by another column, where will I add the condition?

[TheDistractionStudio]

I saw the Twitter poll. Came here to watch the video 😂

[amarnadhg]

Look into order of supplier changes, index not accurate

[pavelandreev]

Hi Ruth, thx for the video. Could you breakdown this function in the RANK(x) case, for your subscribers from Moscow 🤭😁?