Forum Discussion
Anonymous
7 years agoNot applicable
Error in DATESYTD calculation
Hey, guys, I have been doing a PBI dashboard to see the positions closed by recruiter in the Tech Company I work. I need the average by active recruiter by month and by year. In order to do that...
- 6 years ago
Anonymous
You may take a look at the post below.
https://community.powerbi.com/t5/Desktop/monthly-average-of-daily-sums/m-p/291451#M128396
tkrupka
Resolver II
7 years agoDo you have the actual measures formulas you are using?
- Anonymous7 years agoNot applicable
Hello, tkrupka , thank you for the reply! Yes, I have.
1. Calculate the active recruiters in the time context:
Recruiters = CALCULATE ( COUNT ( 'Recruiters'[Qtde recruiters] ); FILTER ( 'Recruiters'; 'Recruiters'[De] <= MIN ( Data[Data] ) ); FILTER ( 'Recruiters'; 'Recruiters'[Considerar até] >= MAX ( Data[Data] ) ) )2. Calculate the positions closed in the time context:
Positions Closed = CALCULATE ( SUM ( Position[Number of Positions] ); FILTER ( Position; Position[Status] = "Closed" ); FILTER ( 'Closing Data'; 'Closing Data'[Closing Data] >= MIN ( Data[Data] ) && 'Closing Data'[Closing Data] <= MAX ( Data[Data] ) ); FILTER ( 'Recruiters'; 'Recruiters'[De] <= MIN ( Data[Data] ) ); FILTER ( 'Recruiters'; 'Recruiters'[Considerar até] >= MAX ( Data[Data] ) ) )3. Calculate the sum of the average positions closed by number of active recruiters:
Sum of AVG = CALCULATE ( [Positions Closed] / [Recruiters]; DATESYTD ( Data[Data] ) )