Forum Discussion

HenryJS's avatar
HenryJS
Post Prodigy
5 years ago

Add Cumulative

Hi all,   How can I add a column that states IF 'custom' is in the future then add a 15 cumulative total for each row?   30 May 2021      15 06 June 2021      30   etc    
Data Protection
Need Help
Show and Tell
Tips and Tricks
Fowmy's avatar
Fowmy
Super User
5 years ago

HenryJS 

You can add the following DAX calculated column:

Cumm = 
IF( 
    Table[Custom] > TODAY() , 
    RANKX( FILTER(Table,Table[Custom] > TODAY() ) , Table[Custom], , ASC) * 15
)