Add a sequence number to a list of values

[Rigolleto]

HI,

I need help to create a sequence number as the photo shows,  notice that I have the color duplicate, that is correct, every color belong to a different Style, I need a DAX code to built the sequence and used it later in a calculation 

Thanks

[Ashish_Mathur · Accepted solution]

Hi,

In the Query Editor, create an Index number column from 1.  Thereafter, write this calculated column formula

=CALCULATE(DISTINCTCOUNT(Data[Attribute]),FILTER(Data,Data[Index]<=EARLIER(Data[Index])))

Hope this helps.

[TomMartens]

Hey,

I'm not sure if I understand your requirement 100%, but maybe this is what you are looking for.

Create a calculated column using this DAX (not complete):

<nameofthecalculatedcolumn> = 
var thisAttribute = '<yourtablename>'[Attribute]
return
SWITCH(
   thisAttribute
    ,"FRISALES", 1
    ,"MONSALES", 2
    ,...
)

Hopefully, this is what you are looking for.

If not please create a pbix that contains sample data that represents your table structure, upload the pbix to onedrive or dropbox and share the link.

Regards,
tom