DAX Fridays!

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:
Earlier function: • DAX Fridays! #13: EARLIER
Quiz: • DAX Fridays! #164: Thi...
Get Northwind Dataset: • Northwind data source:...
Link to DAX Fridays survey: bit.ly/2MMM4KK
Here you can download all the pbix files: curbal.com/don...
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/cou...
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/...
▼▼▼▼▼▼▼▼▼▼
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:
curbal.com/pro...
Many thanks in advance!Here you can download all the pbix files: curbal.com/don...
▲▲▲▲▲▲▲▲▲▲
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
************
************
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Twitter ► @curbalen, @ruthpozuelo
Facebook ► goo.gl/bME2sB
#daxfridays #curbal #SUBSCRIBE

[@annarozyc5184]

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

[@CurbalEN]

Well done!!

[@ximenanunezcams6258]

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

[@341414]

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.

[@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?

[@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)

[@CurbalEN]

You will soon, it took me some time too :) /Ruth

[@SgtLostSpartan]

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

[@CurbalEN]

Un placer!

[@SgtLostSpartan]

@@CurbalEN so... Is there a possibility that you know what can I include to start an index not at 00:00, but at 06:00? And for the values below 06:00 of the same day to continue the sequence? For example, 6 am is 1, 5 pm is 2, 11 pm is 3 and 1 am of the same day is 5.

[@ShabnamKhan-vk7fj]

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.

[@icedojo]

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

[@winzero08]

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!!

[@rohaneashley9287]

I have a similar issue, would love to see how to get this as a measure

[@poojasahasrabhojanee971]

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

[@alonsocarballo2614]

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.

[@VenkateshReddy-cy7it]

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.

[@hamzashafiq573]

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

[@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?

[@juanignacioXI]

Great Video and Dax Functions!!! Ty Ruth

[@CurbalEN]

Happy Friday!! /Ruth

[@Jpalfarog]

THAAAAAAAAAAAAAAAAAAAAANKS !

[@CurbalEN]

Yeyyyyyyy!

[@amarnadhg6896]

Look into order of supplier changes, index not accurate

[@user-qw8wb9uq6w]

great job

[@user-se9ct4yh1w]

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

[@CurbalEN]

Wonderful to hear!

[@2404Pepe]

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

[@CurbalEN]

Saludos Luis :) /Ruth

[@huynguyenquang9964]

Great trick

[@totvabe1]

Could it be possible to use this index in the table of the bump chart's video to determine the ranking?

[@CurbalEN]

Yes, and I will show next Friday another way to create an index that is probably the most common , stay tuned! /Ruth

[@rajatsood2008]

hi just curious. how does

[@CurbalEN]

It takes the columns in alphabetical order I believe. /Ruth

[@powerbinareal]

Sempre top!!!

[@CurbalEN]

Obrigada! /Ruth

[@walidkhlil2872]

Thanks as usual great

[@CurbalEN]

My pleasure! /Ruth

[@pavelandreev6023]

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

[@CurbalEN]

Sure, that is probably the one you were expecting right? Will do, /Ruth

[@pavelandreev6023]

Curbal yep! Thx 🙏 😎

[@Gerschk]

Hi Ruth! I did this successfully on a table with supplier and date instead of location. So the index increments on for each date for each supplier. All is well until I need to filter the date. How can I have the index "reset" after changing the date filter?

[@NaraMeerammaTrust]

I gone through this video. Ruth, What is the real time usage of this? where do we need this kind of index? Can you please give some idea about the practical usage of this? Thank you.

[@CurbalEN]

I have created that index for a customer that wanted to have an I'd number for each row. In his case I created two indexes , so they final result is; Supplier A : India : 30 days: 1.1 Supplier A : India : 60 days : 1.2 Supplier B : Spain :30 days : 2.1 Hope this helps! /Ruth

[@NaraMeerammaTrust]

@@CurbalEN Ruth, But in our example, we have some duplicate index numbers having number 1 for both A,India and B,Braizl. I don't understand what purpose it serves. The example you shown in the reply is different and it makes sense. can we create the index that way having some unique numbers for the combination of two columns>

[@CurbalEN]

Yes, they will then filter by supplier getting only 1.1 and 1.2 and 2.1. /ruth

[@NaraMeerammaTrust]

@@CurbalEN How to do filter by supplier? Do you wanted me to do on visual or on table? can you please help me on this final step to get the numbers like 1.1,1.2 and 2.1

[@NaraMeerammaTrust]

when i do filter on supplier then i ma getting like whole numbers like 1,2,3 only

[@gerardograna]

Hi, I can´t nest EARLIER function.

[@rick_.]

What about if the sort order of the data jumbled?

[@CurbalEN]

It sorts the location column in alphabetical order , so in this case India will always be 1. /Ruth

[@perezmarcone]

Hola Ruth, y este index para que lo utilizaria?

[@CurbalEN]

Para crear un indice de filas por supplier. Por ejemplo: Supplier A : India : 30 days: 1.1 Supplier A : India : 60 days : 1.2 Supplier B : Spain :30 days : 2.1 /Ruth

[@TheDistractionStudio]

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

[@CurbalEN]

😂😂😂 Now you have to go back and vote! /Ruth

[@TheDistractionStudio]

Lol: I did :)

[@AmdiSilword]

Hi Ruth, I have read about VAR. Did your e.g. with VAR and came to the same result as in the video. Index = VAR _Supplier=Supplier[Supplier] VAR _Location=Supplier[Location] RETURN CALCULATE( DISTINCTCOUNT(Supplier[Location]); FILTER( Supplier; Supplier[Supplier]=_Supplier && Supplier[Location]

[@CurbalEN]

Yes! That is a great idea! /Ruth

[@mgcorporation405]

Dax index will half..., Trump 😂😂😂😂

[@mgcorporation405]

Dax will be half , namste Trump 😂😂😂😂😂😂😂😂😂😂😂

[@CurbalEN]

What did I say now? 😂😂😂 /Ruth