I'm trying to represent some data in the form of a cumulative line graph. The data i have attached is made up to illustrate the type of thing I am trying achieve using powerbi. I would also like to be able interactively slice by Division.
Any help would be appreciated.
Solved! Go to Solution.
Hi @AndyRob1973 , you need to create a calculated column with the next code:
Column = CALCULATE(SUM(Acum[recruits]); FILTER ( Acum; Acum[YEAR] <= EARLIER ( Acum[YEAR] ) && Acum[Month] <= EARLIER ( Acum[Month] ) && RIGHT(Acum[YEAR];2)=RIGHT(EARLIER(Acum[YEAR]);2) && Acum[Division]=EARLIER(Acum[Division]) ) )
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.