Forum Discussion
Helper IRunning Total for non date column
Skilled SharerHi sharong ,
Can you only share you sample table as well as a expected output table for it. so that it will be easy for me to test it out too.
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!
Helper IThis is the existing table i have. I want a new column "Running sum" of receivables based on rank st.
Total number of rows in dataset is 18079 rows.
- NikhilChenna
Hi sharong ,
Create the below measure ,
Running total sales =
VAR IndexRank = [Rank ST]
RETURN
CALCULATE (
SUM ( 'table1'[Receivables]),
FILTER (
ALL ( 'table1'[customer_no] ),
IndexRank
>= RANKX ( ALLSELECTED ( 'table1'[customer_no] ), [sum],, ASC, DENSE )
)
)
Regards,
Nikhil Chenna
Appreciate with a Kudos!! (Click the Thumbs Up Button)
Did I answer your question? Mark my post as a solution!- sharong
Hi NikhilChenna
This too is not working. The table visual keeps loading. Can you please help me out. 18k rows is a small dataset. Dont know why it keeps loading. Please help me out. Struck with this for last 1 week- NikhilChenna