I have closing date. I also have a measure called commitment amount. User will choose a date from filter / parameter. Based on that date all commitment amount should be aggregated.
What is the best way ?
2 answers
Try with running total calculation
Below image for Normal calculation:-
Below image is for Running total calculation:-
Click on SUM(Sales) like below Image
Please let me know if you have more question on this.
Please mark correct and Helpful if it works for you.
Best
Suman
