Forum Discussion

Omneah's avatar
Omneah
Frequent Visitor
5 years ago

Calculations with multiple dates

Hi everyone,    I am working on an HR measure where we are trying to see how often leaders (positions) are changing in our organization.  I have for each position, the employee who held the positi...
Omneah's avatar
Omneah
Frequent Visitor
5 years ago

Hi wdx223_Daniel @

 

Thank you for your reply. I tried it and for some reason I get the same results repeated for each year but it's different by the department. 

Do I need to create a relationship with the DimStatus table and any other tables? 

 

Thanks,

Omneah

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
5 years ago

DimStatus has not any relationship with any table.

have you put the column of Status on the legend?