Forum Discussion
Employee Turnover
Hey Smoupre,
I can append both tables together also there is no special reason to use both tables separate. The only reason for using both tables separated is to build relationship and to make the formula more dynamic and functioning. The calculated measure can work for both Month slicer and year slicer also.
Looking forward some magic from you guys.
Regards,
Muhammad Siddiq
MuhammadSiddiq,
Please help to post expected result based on the new sample tables you shared.
Regards,
Lydia
okay i am attaching shortly
Hey Lydia,
Below is the expected result from the attached 2 table. The approach and formula will same as you calculated in first example i.e 8%.
But now 2 separated tables are uploaded to data models and are lonked with the dimension table and we need to calculate the same turnover using the previous approach and formula. The expected results are ;
Month - Turnover%
Jan 33% Feb 67% March 33% April 33% May 33% June 33% July 50% August 50% Sept 50% Oct 100% November 100% December 100% Yearly Turnover 578% we need to calculate the monthly turnover as well as yearly from the data table using sums and averages but with the same previous approach.
Regards,
Muhammad Siddiq
any luck on the above solution?