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