Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

conditional counter

Hello everybody, I want to know if it's possible to create a column starting at 0 and increasing by one unit every time the value one occurs in another column. This is what I want to obtain :   ...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    7 years ago

    Anonymous 

     

    So you can sum NB for all indices before current row..right?

     

    =
CALCULATE (
    SUM ( table1[Nb] ),
    FILTER ( Table1, [Index] <= EARLIER ( [Index] ) )
)
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
7 years ago

Anonymous 

 

So you can sum NB for all indices before current row..right?

 

=
CALCULATE (
    SUM ( table1[Nb] ),
    FILTER ( Table1, [Index] <= EARLIER ( [Index] ) )
)
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks ! That was exactly what I wanted, looks really easy ahah but I'm just starting to dive into Power Bi !
    This query suceed on the little table I gave you but I'm working with a table of 50 000 rows and I'm facing a memory problem.