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, thanks for your reply.
Attached you can find a PBIX example.
It is important to emphasize that in my real case I work with Direct Queries
Hi,
I managed to solve the previus issue by changing the measure to the following :
Prev Value = CALCULATE ([Return] ,DATEADD ( KeyPerformanceMonthly[Start of Month],-1,MONTH ))
Now I need your help to calculate the Accumulated Performance
Updated PBIX attached