Forum Discussion
CMajka8
Helper II
Helper IIRunning Total based on sorted column
Hello - I am looking for a running total DAX formula, however, most of the examples I see use a date column in the fromula. I do not have a date column. The dataset is sorted DESC by Premium. th...
HI:
I'll take a guess as not too much has been shared about data model or this is a single table. I hope this helps!
You can start off with a measure that will be referenced by this calc col.
Total Premium = SUM(Table[Premium])
then add this as calculated column in your table.
Premium Amt = [Total Premium]
Cumulated Premium =CALCULATE([Total Premium],ALL( TableName ),TableName[Premium Amt] >= EARLIER( TableName[Premium Amt]))
Whitewater100
Solution Sage
Solution SageHI:
I'll take a guess as not too much has been shared about data model or this is a single table. I hope this helps!
You can start off with a measure that will be referenced by this calc col.
Total Premium = SUM(Table[Premium])
then add this as calculated column in your table.
Premium Amt = [Total Premium]
Cumulated Premium =
CALCULATE(
[Total Premium],
ALL( TableName ),
TableName[Premium Amt] >= EARLIER( TableName[Premium Amt]))
- CMajka8
Yes, this works - thank you!
