Forum Discussion
DavidWaters100
Post Patron
Post PatronRunning total not working as expected
Hi,
I am trying to return running total in the following measure. My "main table" is joined to a "Dev Months" table which contains all month numbers, whereas the main table can contains gaps, ...
Hi DavidWaters100 ,
Believe that your filtering is incorrect because of the way you are using the MAX.
Since you have a relationship between both tables when you use the syntax
ISONORAFTER('Dev months'[Dev Month], MAX('Main Table'[Development Month ])Basically you are picking up the values even if there aren't any data believe that you need to use something similar to:
FILTER (DevMonth; DevMonth[Month] <= MAXX(ALL(MainTable[Development Month]);MainTable[Development Month]))Be aware that I have writen this by head, did not make any test with any data.
DavidWaters100Post Patron
Post Patronupdate - just realised if I change the Max to 'Dev months'[Dev Month]), it does work.
However the Max is there to stop values returning when the dev month gets too high - for example for year 2020, there are only 9 dev months to September. I need to prevent "future" dev months from showing values!