Forum Discussion
Running Total Showing Wrong Values
I am using the below function to calculate the 12 month running total of items. When all the periods are listed every thing works great. However if I filter and a period is missing a MYSTERIOUS "2" ...
I was able to resolve the issue by adding a seperate date table and not use the date in the main table. I do not know why this fixed the problem or why PBI was putting a MYSTERIOUS 2 when it should have been Null or Zero.
I was able to resolve the issue by adding a seperate date table and not use the date in the main table. I do not know why this fixed the problem or why PBI was putting a MYSTERIOUS 2 when it should have been Null or Zero.