Forum Discussion
Accumulated Performance Calculation
Hello, i have a precalculated monthly performance table and i want to create a measure that calculate accumulated performance. accumulated performance shuold be calculated from the date that user c...
Hi ziva5 ,
I can't open the sample you provided due to some missing files, but you can try this measure:
Prev Value = CALCULATE ([Return] ,FILTER ( ALL(KeyPerformanceMonthly),KeyPerformanceMonthly[Start of Month]=[Prev Month] ))
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.