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
amitchandak's avatar
amitchandak
Super User
5 years ago

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's avatar
    HenryJS
    Post Prodigy
    5 years ago

    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