Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello all,
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.
Thanks
Andy
Solved! Go to Solution.
Ok, if you have any question here we are.
I have tried the solution and works fine.
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]) ) )
Best Regards,
Miguel
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks MIguel,
I will try that as soon as possible.......if it works I have a further question!
Thanks for your time
Ok, if you have any question here we are.
I have tried the solution and works fine.
User | Count |
---|---|
124 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
137 | |
116 | |
102 | |
71 | |
61 |