DAX - Incrimental Count of a Column

[Anonymous]

Hello All,

I am new to power bi and DAX,

I am trying to calculate count of a column in incremental way in a CALCULATED COLUMN so that i can find out how any times that value got repeated.

Data and required output as mentioned below 

Any help please.

Thanks,

Mohan V.

[Fowmy · Accepted solution]

@Anonymous 

Use can do in Dax by sorting YEAR, then  COLUMN1 and adding an index number in Power Query, then add below create below column in the model:

Result = 
CALCULATE(
    COUNTROWS('Table'),
        CALCULATETABLE('Table',
            'Table'[Sequence]<=EARLIER('Table'[Sequence])
        )         
)

It will be ideal to add it using Power Query:

Refer to this: poet and video: https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

Let me know if it doesn't work.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn

[amitchandak · Accepted solution]

@Anonymous , you need add and index column

and then have it like this

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

new column = countx(filter(Table,[year] =earlier([Year]) && [column1] = earlier([column1]) && [index] <= earlier([index])),[index])

[v-deddai1-msft · Accepted solution]

Hi @Anonymous ,

First, you need to create an index colum in query editor:

Then you can use the following calculated column:

Column = CALCULATE(COUNT('Table'[Column1]),FILTER(ALLEXCEPT('Table','Table'[Year],'Table'[Column1]),'Table'[Index]<=EARLIER('Table'[Index])))

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak · Accepted solution]

@Anonymous , you need add and index column

and then have it like this

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

new column = countx(filter(Table,[year] =earlier([Year]) && [column1] = earlier([column1]) && [index] <= earlier([index])),[index])

[Fowmy · Accepted solution]

@Anonymous 

Use can do in Dax by sorting YEAR, then  COLUMN1 and adding an index number in Power Query, then add below create below column in the model:

Result = 
CALCULATE(
    COUNTROWS('Table'),
        CALCULATETABLE('Table',
            'Table'[Sequence]<=EARLIER('Table'[Sequence])
        )         
)

It will be ideal to add it using Power Query:

Refer to this: poet and video: https://radacad.com/create-row-number-for-each-group-in-power-bi-using-power-query

Let me know if it doesn't work.

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

I accept KUDOS 🙂

YouTube, LinkedIn