Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
n2p2gupta
Frequent Visitor

Calculate cumulative count by looking values in a column

How can I create a column "Result" below by keepin a count of repeating values from Col1?  Thanks.

Col 1    Result

   a              1

   b              1

   a              2

   c              1

   b             2

   a             3

   c             2

3 REPLIES 3
n2p2gupta
Frequent Visitor

Thanks Eric!


@n2p2gupta wrote:

Thanks Eric!


@n2p2gupta

If you have no further question, could you accept the reply as solution to close this thread? For any question, feel free to post.

Eric_Zhang
Employee
Employee


@n2p2gupta wrote:

How can I create a column "Result" below by keepin a count of repeating values from Col1?  Thanks.

Col 1    Result

   a              1

   b              1

   a              2

   c              1

   b             2

   a             3

   c             2


@n2p2gupta

You need an index column to indicate the rows order.

Capture.PNG

 

Then create a calculated column as

Result =
RANKX (
    FILTER ( 'Table', 'Table'[Column1] = EARLIER ( 'Table'[Column1] ) ),
    'Table'[Index],
    ,
    ASC,
    DENSE
)

Capture2.PNG

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.