Forum Discussion
Solved
Rolling calculation
Hey, I´m trying to port reports from Crystal Reports and can´t get one visual created. I´m pretty sure its not that complicated but no way so far. Its about reporting for a ticketing system, we want...
Hi rttplm,
Makes this change to.your.measure
Measure_ =
VAR date_selector =
MAX ( Tickets[Report Date] )
RETURN
CALCULATE ( SUM ( Tickets[Indicator] ),ALL(Tickets),Tickets[Report Date] <= date_selector )
However depending on the size of.your table you may get some performance issues, please check if its works fine if not please tell me si i can change it. Not in the computer righth now to test another formula.
Regards,
MFelix
Makes this change to.your.measure
Measure_ =
VAR date_selector =
MAX ( Tickets[Report Date] )
RETURN
CALCULATE ( SUM ( Tickets[Indicator] ),ALL(Tickets),Tickets[Report Date] <= date_selector )
However depending on the size of.your table you may get some performance issues, please check if its works fine if not please tell me si i can change it. Not in the computer righth now to test another formula.
Regards,
MFelix
Hi rttplm,
Good to know it works, but please check if you don't get any performance issues, it's not a good practice to make a ALL filter to a table we should do it to specific fields,
If needed I can check to improve that formula if your table is not very big you can leave as is.
Regards,
Mfelix