Data Flow and Fact Tables

[Syndicate_Admin]

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.

[amitchandak]

@Syndicate_Admin , Do you have SCD employee dimension?

Refer video from Guyincube - https://www.youtube.com/watch?v=tKeaQpWynzg

[Syndicate_Admin]

No, it doesn't.