Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Runing total by row

Hi, i have seen this asked a few times but i have been unable to use this for my task I have a column for Wind direction and one for timestamp as well as various other columns that are filtering ...
Need Help
Samarth_18's avatar
Samarth_18
Community Champion
5 years ago

Hi Anonymous 

 

You can create a measure with below code:-

cumulative_total=
CALCULATE (
SUM ( 'table'[<values column>] ),
FILTER ( ALL ( 'table'[date] ), 'table'[date] <= MAX ( 'table'[date] ) )
)

Thanks,

Samarth

  • ryan_mayu's avatar
    ryan_mayu
    Super User
    5 years ago

    Anonymous 

    pls try this

     

    Measure = CALCULATE(sum(test[Valid Data]),FILTER(test,'test'[WD (bins)]=max('test'[WD (bins)])&&'test'[Date]<=max('test'[Date])))

     

     

    if you want the total to display the correct value , create another measure

    Measure 2 = sumx(test,[Measure])