Forum Discussion

carlosflores's avatar
carlosflores
Icon for Helper I rankHelper I
7 years ago

Help measures from different related tables

Hey Community, I'm having problems calculating the rotation ratio (been at it for over a week now .__.   This are my relationships:     Ceses = Leaves in company Ingresos = Hires in the c...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi carlosflores

I want to confirm with you what is your expected result.

For example, "Hires" and "Leaves" are total sum of the whole month, "actives" is the total active workers for the whole 2018/9, then according to information above, we could get the last column/measure which shows total active workers for each month. 

 

 

Is my understanding right?

Could you send me a privacy email with your example dataset?

It has mutiple tables and i need to know more about your data.

 

Best Reagrds

Maggie

carlosflores's avatar
carlosflores
Icon for Helper I rankHelper I
7 years ago

v-juanli-msft thanks for you help,

 

"Hires" and "Leaves" are total sum of each day, and can be filtered by month or year or client.

 

"Actives" is the total of workers on september 17, that's when I collected the data

 

Your last column "actives2" is actually correct.

 

Lastly to finally calculate the rotation ratio, I would have to divide leaves/ actives2, and this should be able to be filtered by month, year or client.

 

Alsi, I sent you a private message with the dataset.

 

Thank you so much!