Data Flow and Fact Tables

I have several tables of facts, sales, hours, and a flow with employees and their superior. The employee can change over the course of the time of the superior, I want to know the superior at all times of the sale, I don't want to do it by var in the fact tables, but in a summary table that I have where the employees appear to me only once. How can I do that? Since it gives me the current superior, but if I filter by previous months in the visual, it doesn't give me the previous one but always the current one.