Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello good afternoon, I am trying to find a way to get an accumulated of the totals per period for the number of employees I have in my company.
To put them in context, for each sector (Operational, Project, Technical Staff) the total number of employees I currently have working is calculated. I have the measurement made as follows.
I need you to accumulate the totals that are calculated by period, that is, for the period 2020-01 I have a total of 7 people, for the period 2020-02 I have a total of 12, but I would like you to also add the period 2020-01 and so on.
Any help?
Thanks a lot!
Hi @Syndicate_Admin ,
Please have a try.
No trabajadores a Fecha=
var fechaComparacion=lastdate(dates[Fecha])
return
calculate(countrows(capacityactual),filter(capacityactual, capacityactual[fecha alta de recurso]<=fechaComparacion&&capacityactual[fecha desafectacin>=fechaComparacion&&date<=earlier(table[date])))
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, how are you?
I couldn't get to the solution with what happened to me, what I'm trying to do is a matrix like this.
I want the totals to accumulate as the periods go by. I attach in a drive also the pbix file to see more details.
https://drive.google.com/file/d/16atjLi2nBUOZ686I0fzUYLFeSvoyLBKF/view?usp=share_link
Thanks a lot!
Hi @Syndicate_Admin ,
Please refer to my pbix file to see if it helps you.
Measure 2 =
var cur_periodo=FORMAT( SELECTEDVALUE(Calendario[Periodo]),"YYYY-MM")
var cur_aten=SELECTEDVALUE(RRHH[Atención Demanda])
var tmp=FILTER(ALL(RRHH),RRHH[Atención Demanda]=cur_aten&&FORMAT( RRHH[Fecha Alta de Recurso],"YYYY-MM")<=cur_periodo)
return
COUNTROWS(tmp)
// cur_periodo
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello again, you know that I was verifying the pbix with the resolution but you know that I am not totaling the values.
What I need is to show it in a matrix as I show you there, but if filter for the year does not show me the totals, and another drawback that I am verifying is that the periods if I take out the year filter are shown to me in a disorderly way.
This is what you had presented to me but note that although the accumulated is done but with disorderly periods.
Thanks a lot!
Hello again, you know that I was verifying the pbix with the resolution but you know that I am not totaling the values.
What I need is to show it in a matrix as I show you there, but if filter for the year does not show me the totals, and another drawback that I am verifying is that the periods if I take out the year filter are shown to me in a disorderly way.
This is what you had presented to me but note that although the accumulated is done but with disorderly periods.
Thanks a lot!