Forum Discussion

Jammer8888's avatar
Jammer8888
Frequent Visitor
9 years ago
Solved

Creating a cumulative column breaking on another column - help !

  Hi,   I am new to Power BI and I am looking for a very simple way to bring back the 'Cume' column (shown in the example below) into my dataset so I can filter on the Cume = '1' to get a unique v...
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    Jammer8888

     

    Hi, a way to solve this:

     

    in Edit Query:

     

    Add a Index Column --Close & Apply

     

    After this:

     

    Create a new column 

     

    Cume=RANKX(FILTER(Table1,Table1[Colour]=EARLIER(Table1[Colour])),Table1[Index],,ASC)

     

    Regards

     

    Victor

    Lima - Peru

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

Jammer8888

 

Hi, a way to solve this:

 

in Edit Query:

 

Add a Index Column --Close & Apply

 

After this:

 

Create a new column 

 

Cume=RANKX(FILTER(Table1,Table1[Colour]=EARLIER(Table1[Colour])),Table1[Index],,ASC)

 

Regards

 

Victor

Lima - Peru

 

  • Jammer8888's avatar
    Jammer8888
    Frequent Visitor
    9 years ago

    That is great Victor - a simple and elegant solution. Thank you very much for your help on this.

     

    Chris.