Forum Discussion

3 Replies

  • 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
)

     

     

  • 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