Add Cumulative

[HenryJS]

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

[Fowmy]

@HenryJS 

You can add the following DAX calculated column:

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

[amitchandak]

@HenryJS , not very clear. Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

Try a new column  like

sumx(filter(Table, [custom] <=earlier([custom])),[QTY])

[HenryJS]

@amitchandak I want to add a new DAX column that states if Week Ending is in the future then add a cumulative 15 for each week

so if week ending is in future each week ending adds 15 cumulatively, 15, 30, 45, 60 etc for each week in future