Forum Discussion
Running total calculation without filter?
OK I think I found it, add "<" to this measure
Looking good!
Hey,
I have been trying hard to understand the logic of your measure but in vain, however I can say that this 'Calendar'[0BeforeActualYearMonth] is of type Text and numbers therefore not possible to compare it to a scalar of type number, I am refering to
Conclusion : I am not sure the filter is working properly and I wonder if the result is thus correct!
Hey aj1973,
Ok, I changed the type of the 0BeforeActualYearMonth from text to number and modified the related measures according to the changes. Here is the result: RunningTotalDemoWithCalendar1_aj1973_3
I don't see any significant changes in the result. If the running total with start balance works then the 0 column (this was 0BeforeActual value in the previous versions) is not visible. If the 0 column is visible then the running total does not work.
So, back to my original question:
"Is there any way to create running total calculation without filtering the "0BeforeActual" column?"
Thank you!
OK I think I found it, add "<" to this measure
Looking good!
Hey aj1973,
yes, you did it!! Thank you for your solution and your efforts and patiance during this loong conversation
Have nice day!
IF condition.
https://drive.google.com/file/d/1sxZeTXPSJIuIepzG2v2ckvBsnbW_Pe9u/view?usp=sharing
This is how I found out that your measure is missing the "<"
Hope your dilema is over.
Indeed,
Welcome